22,207
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE P_set
@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