January 4, 2012

Error Handling in SQL


Declare @Error int


set @Error = @@ERROR                    

                if @Error = 0
set @Error = @@ERROR


IF @Error = 0
BEGIN
COMMIT  tran
END  
ELSE
BEGIN
ROLLBACK tran
END

No comments:

Post a Comment