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

2 votes147 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote151 views1 answer
Sql decode
SQL
0 vote145 views1 answer
Mysql find missing values
SQL
0 vote157 views1 answer
Sql bild in function
SQL
1 vote183 views1 answer
Backup mysql schema only
SQL
0 vote145 views2 answers
Sql having multiple conditions
SQL
0 vote173 views1 answer
Sql insert query list of dictionaries
SQL
0 vote141 views1 answer
Sql string length postgresql
SQL
0 vote170 views2 answers
Insert data mysql with cmd
SQL
5 votes149 views3 answers
Oracle first day of last year
SQL