Sql try catch

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

Similar codes

6 votes141 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote142 views1 answer
Traccar mysql
SQL
3 votes137 views2 answers
Sql end of month
SQL
0 vote160 views1 answer
Including parameters in OPENQUERY
SQL
0 vote205 views2 answers
Fanyi
SQL
6 votes183 views2 answers
Install psql mac
SQL
1 vote169 views1 answer
Homebrew install mysql
SQL
7 votes148 views1 answer
Query delete duplicates
SQL
1 vote132 views1 answer
Declare table variable
SQL
0 vote146 views1 answer
Sql include rows with 0 values
SQL