CREATE PROCEDURE zd_kjjLogin |
@Id Int output, |
@userClass nvarchar(20) output, |
@department nvarchar(20) output, |
@purview nvarchar(20) output, |
@userName nvarchar(20), |
@passWord nvarchar(20), |
@IP nvarchar(20) |
AS |
if exists(select id from [zd_user_admin] where UserName = @userName and [Password] = @passWord) begin |
begin transaction |
update [zd_user_admin] set LastLoginTime = getdate(), LastLoginIP = @IP,logins = logins+'a' where UserName = @Username |
if @@error <>0 begin |
--捕获错误一般是这样的。 |
--加这一句,在前台程序可以捕捉到。 |
raiserror('这里写上你的错误提示',16,1) |
--****************************************** |
rollback transaction |
return -1 |
end |
commit transaction |
select @Id=Id,@userClass=userClass,@department=department,@purview=purview from [zd_user_admin] where UserName = @userName |
return 0 |
end |
return 1 |
ql2000存储过程事务如何捕获返回错误代码
最新推荐文章于 2021-09-25 16:39:12 发布