ttry

Snippet Name: ttry

Tags: helpful,scriptgeneration

Created Date: Oct 1 2021 8:05AM
Last Modified Date: Mar 25 2022 10:08AM

–desc: simple try catch

Dependencies: none-standalone code

default description

Sample Output:

--desc: simple try catch
 
 BEGIN TRY
 
 {C}
 
 END TRY
 
 BEGIN CATCH
 
 DECLARE @ErrorSeverity INT,
 
         @ErrorNumber   INT, 
 
         @ErrorMessage  NVARCHAR(4000),
 
         @ErrorState    INT
 
 SET @ErrorSeverity = ERROR_SEVERITY()
 
 SET @ErrorNumber   = ERROR_NUMBER()
 
 SET @ErrorMessage  = ERROR_MESSAGE()
 
 SET @ErrorState    = ERROR_STATE()
 
         PRINT 'Msg ' + convert(varchar,@ErrorNumber) + ' Level ' + convert(varchar,@ErrorSeverity) + ' State ' + Convert(varchar,@ErrorState) + CHAR(13) + CHAR(10) + @ErrorMessage
 
 
 
 END CATCH
 
 
 
 

Leave a Reply