How to Handle the exceptions in Sqlsrver 2005??
Answer Posted / neetu
In SQLSERVER 2005 exceptions are handle by using RaisError
with Try catch like in other prog languages.
Begin Try
End try
Begin Catch
End Catch
BEGIN TRY
RAISERROR ('Yaa, I ma the problem', 16,1)
END TRY
BEGIN CATCH
SELECT ERROR_NUMBER() as ERROR_NUMBER,
ERROR_SEVERITY() as ERROR_SEVERITY,
ERROR_STATE() as ERROR_STATE,
ERROR_MESSAGE() as ERROR_MESSAGE
END CATCH
ERROR_NUMBER() returns the number of the error.
ERROR_SEVERITY() returns the severity.
ERROR_STATE() returns the error state number.
ERROR_PROCEDURE() returns the name of the stored procedure
or trigger where the error occurred.
ERROR_LINE() returns the line number inside the routine that
caused the error.
ERROR_MESSAGE() returns the complete text of the error
message. The text includes the values supplied for any
substitutable parameters, such as lengths, object names or
times.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do I find my localdb version?
what is difference between view and Dip.
What is the user of Primary key?
Can we perform backup restore operation on tempdb? : sql server database administration
What is acid db?
What are synonyms?
How to transfer data from a cursor to variables with a "fetch" statement?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
What is 2nf normalization?
How to create a testing table with test data in ms sql server?
What is an index in sql?
What are subquery and its properties?
What is similarity and difference between truncate and delete in sql?
How to change server name in sql server?
What are the main sources of data?