Posts

Showing posts from March, 2012

TSQL error handling scope and mechanism

Three levels of SQL statement execution result status and reactions.


1) statement termination
2) scope abortion
3) batch abortion


To read more about it please follow the below link with video~


http://blog.sqlauthority.com/2012/02/15/sql-server-t-sql-errors-and-reactions-sql-in-sixty-seconds-002-video/
TRY CATCH http://blog.sqlauthority.com/2007/04/11/sql-server-2005-explanation-of-trycatch-and-error-handling/