4. How would you handle error in SQL SERVER 2008?

How would you handle error in SQL SERVER 2008?

Answer

SQL Server now supports the use of TRY...CATCH constructs for providing rich error
handling. TRY...CATCH lets us build error handling at the level we need, in the way we need
to, by setting a region where if any error occurs, it will break out of the region and head to
an error handler. The basic structure is as follows:
BEGIN TRY
<
code
>
END TRY
BEGIN CATCH
<
code
>
END CATCH
So if any error occurs in the TRY block, execution is diverted to the CATCH block, and the
error can be dealt
.

All sql Questions
Ask your interview questions on sql

Write Your comment or Questions if you want the answers on sql from sql Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---