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

1 vote151 views1 answer
How to change owner in postgres
SQL
0 vote158 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
10 votes154 views4 answers
Sql pagination
SQL
7 votes159 views1 answer
Connect mysql docker
SQL
0 vote154 views1 answer
Get all employees if name ends with in sql
SQL
0 vote213 views1 answer
Insert query return id mysql
SQL
2 votes172 views3 answers
Sql interview query questions
SQL
0 vote149 views1 answer
Connecting to my cloud sql server with c#
SQL
1 vote184 views2 answers
Sql select only row with the max date
SQL
0 vote156 views1 answer
Drop specific row postgresql
SQL