Using Try Catch Block In SQL Server 2005

[Aaryn]

I am using SQL Server 2005 & Wnated to block the transaction which i enclose in try catch block. How can i get all the associated details in the catch block...???

Please Help.....!

[opaper]

The syntax for a TRY/CATCH block is as Follows :

BEGIN TRY
     {  sql_statement | 
 statement_block  }
END TRY
BEGIN CATCH
     {  sql_statement | 
 statement_block }
END CATCH

[MindSpace]

Introduction :
SQL Server 2005 offers several new features over its predecessor, including many features that work with databases more like application code to the letter. NET bildend be sought. For example in SQL Server 2005 can be stored procedures, triggers, UDFs, using any programming language. NET framework, and so forth are written. Another feature and the focus of this article, is SQL Server 2005 's support for ATTEMPT FANG or blocks. EXPERIMENT or FANG-blocks are the standard approach to exception handling in modern programming languages and relate with:

• TRY block-system : the TRY block-system contain the instructions which could lead to an exception
  
  
• A Catch Block : if an exception occurs from one of the statements in the TRY block, control branches to block the margin, where the exception can be processed, annotated, etc..

[Modifier]

SQL Serveur 2005 has remarkablly improved the way in which it is possible to manage the transformation of error in your code T-SQL. The TRY/CAPTURE to block renders it the code easier than logical error. Greater information on specific errors can be given back with the new system error functions. While it is moved to us in ahead with the writing of code T-SQL in SQL Serveur 2005, it is advised to use the TRY/CAPTURE error of system and functions in order to improve your processing error of marks them logical.