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
转载请注明原文地址: https://ibbs.8miu.com/read-2000381.html