---修改---
create proc p_update
(
@ID int,
@Name varchar(50),
@Age varchar(50),
@Sex varchar(20),
@StatId int
)
as
begin
update Stu set Name=@Name,Age=@Age,Sex=@Sex,StatId=@StatId where ID=@ID
end
--测试
exec p_update 2,'张良','27','男',19
---修改---
create proc p_update
(
@ID int,
@Name varchar(50),
@Age varchar(50),
@Sex varchar(20),
@StatId int
)
as
begin
update Stu set Name=@Name,Age=@Age,Sex=@Sex,StatId=@StatId where ID=@ID
end
--测试
exec p_update 2,'张良','27','男',19
转载于:https://www.cnblogs.com/xiaoandong/p/9386395.html
场景：查询人员指定年月工作量信息 USE [Test] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[GetWorkLoadMain] @year int, @month int, @UserId varchar(50) as...