Sunday, 2 December 2012

try catch in stored procedure in sql server


Begin try

---------------


-----
-----
-----
-----

---------------

end try

Begin catch
Select
ERROR_MESSAGE(),
ERROR_NUMBER() ,
ERROR_SEVERITY() ,
ERROR_STATE() ,
ERROR_PROCEDURE() ,
ERROR_LINE()

end Catch

No comments:

Post a Comment