DECLARE @result AS INT
SET nocount ON
SET @result=0UPDATE ....
SELECT @result=(CASE @@rowcount>0 THEN @result+1 ELSE @result END)INSERT ...
SELECT @result=(CASE @@rowcount>0 THEN @result+1 ELSE @result END)INSERT ...
SELECT @result=(CASE @@rowcount>0 THEN @result+1 ELSE @result END)RETURN @result
SET nocount ON
SET @result=0UPDATE ....
SELECT @result=(CASE @@rowcount>0 THEN @result+1 ELSE @result END)INSERT ...
SELECT @result=(CASE @@rowcount>0 THEN @result+1 ELSE @result END)INSERT ...
SELECT @result=(CASE @@rowcount>0 THEN @result+1 ELSE @result END)RETURN @result
--当 SET XACT_ABORT 为 ON 时,如果 Transact-SQL 语句产生运行时错误,整个事务将终止并回滚begin tran....commit tranreturn 0