---修改---
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