摘要：ALTER TRIGGER [dbo].[Trigger_userStatusChangeLog] ON [dbo].[Jinbi_User] for UPDATEAS BEGIN-- SET NOCOUNT ON added to prevent extra result sets from-- interfering with SELECT statements.SET NOCOUNT ON;declare @NewUserStatus int;declare @OrgUserStatus int;declare @UserID int;declare @InWhiteList int; 阅读全文

摘要：ALTER PROCEDURE [dbo].[Proc_Test_commit1] @result int output, --成功 1; 失败 0 @message nvarchar(20) output ASBEGIN SET NOCOUNT ON begin try begin tran yy insert into Test_Commit (b) values (3) insert into Test_Commit (a,b) values (1,3) set @result=1 commit tran yy ... 阅读全文