--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