Try Catch Block in SQL Server 2005
(Vinod Kumar) Error handling in T-SQL has been in question for quite sometime now in SQL Server 2000. It has not been user-friendly and more often than not most of the developers have had doubts in the way it used to work. Now the good news is in SQL Server 2005 this new feature of “TRY…CATCH” is more like the way it works in many programming language. I have to admit this is the new rich error handling capability for T-SQL world.

Read More >>