Monday 2 March 2015

Using Try Catch blocks in SQL Server StoredProcedure

Hi,
    Hear i am Explaining how to use Try and Catch blocks in Sql server StoredProcedure.

Example:-

CREATE PROCEDURE uspTryCatchTest
AS
BEGIN TRY
    SELECT 1/0
END TRY
BEGIN CATCH
    SELECT ERROR_NUMBER() AS ErrorNumber
     ,ERROR_SEVERITY() AS ErrorSeverity
     ,ERROR_STATE() AS ErrorState
     ,ERROR_PROCEDURE() AS ErrorProcedure
     ,ERROR_LINE() AS ErrorLine
     ,ERROR_MESSAGE() AS ErrorMessage;
END CATCH

0/P



No comments:

Post a Comment