create procedure P_set
@UserID int,
@UserName varchar(20),
@UserSex varchar(20),
@UserDesc varchar(20)
--select * from UserInfo where UserID=@UserID
update UserInfo
set UserName=@UserName,UserSex=@UserSex,UserDesc=@UserDesc
where UserID=@UserID
go
@UserID int,
@UserName varchar(20),
@UserSex varchar(20),
@UserDesc varchar(20)
--select * from UserInfo where UserID=@UserID
update UserInfo
set UserName=@UserName,UserSex=@UserSex,UserDesc=@UserDesc
where UserID=@UserID
go
@UserID INT ,
@UserName VARCHAR(20) ,
@UserSex VARCHAR(20) ,
@UserDesc VARCHAR(20)
AS --少了这个
UPDATE UserInfo
SET UserName = @UserName ,
UserSex = @UserSex ,
UserDesc = @UserDesc
WHERE UserID = @UserID
go