일반적인 트랜잭션 처리

DECLARE @ROWCOUNT INT, @ERROR INT, @TRANCOUNT INT;

 

BEGIN TRAN

 

UPDATE TABLE_A SET

      AAA = @AAA

WHERE SEQ = @SEQ

 

SELECT @ERROR = @@ERROR, @ROWCOUNT = @@ROWCOUNT, @TRANCOUNT = @@TRANCOUNT

IF (@ERROR <> 0 OR @ROWCOUNT < 1)

BEGIN

     IF @TRANCOUNT > 0 ROLLBACK TRAN;

     RETURN @ERROR

END;

 

COMMIT TRAN;