Friday, June 3, 2011

TRY...CATCH + BEGIN TRANSACTION in SQL Server a good way for error handling

TRY...CATCH + BEGIN TRANSACTION in SQL Server a good way for error handling than just @@error since the later gives only if last statement made error unlike the former which tracks if error occurs in any statement in that block.
BEGIN TRANSACTION
BEGIN TRY
Try Statement 1
Try Statement 2
...
Try Statement M
END TRY
BEGIN CATCH
ROLLBACK
Catch Statement 1
Catch Statement 2
...
Catch Statement N
END CATCH

COMMIT

Ref: http://www.4guysfromrolla.com/webtech/041906-1.shtml

No comments:

Post a Comment

Devops links

  Build Versioning in Azure DevOps Pipelines