存储过程问题帮忙看下

[Okkkkkk_]

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

[Mr_Nice]

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

[zlw008]

引用 楼主 Okkkkkk_ 的回复:

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,User……

在@UserDesc varchar(20)的下面加个as应该就好了