create proc Pro_reg
@userName nvarchar(10),
@pwd nvarchar(40)
as
if(@userName='' and @pwd='')
return -1
else
begin
begin tran reg
insert into user(username,pwd) value(@userName,@pwd)
if @@error=0
begin
print '注册成功'
commit tran reg
return 1
end
else
rollback tran reg
end