学习存储过程笔记一

第一个存储过程

功能描述： 注册用户，如果存在返0，否则返新用户ID


drop proc pro_user_add --删除

create procedure pro_user_add
@username nvarchar(30),
@pwd nvarchar(50),
@question nvarchar(50),
@answer nvarchar(50),
@email nvarchar(50),
@regip varchar(15),
@regtime nvarchar(50)
as
declare @id int
set @id=0
select @id=id from B_Member where username=@username
if @id>0
return 0
else
begin
insert into B_Member (username,pwd,question,answer,email,regip,MemberLevel,Integral,Isdel,LoginCount)
values (@username,@pwd,@question,@answer,@email,@regip,1,1,0,1)
select @id=max(id) from b_member
return @id
end


declare @result int
execute @result=pro_user_add '3696','456','问题','答案','email','ip',getdate
print @result

select top 100 * from b_member order by regtime desc