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

0 vote176 views1 answer
Django how to get query result count
SQL
0 vote204 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote179 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
4 votes176 views2 answers
Postgres update single column
SQL
0 vote191 views3 answers
Query string not ending with with vowels
SQL
10 votes188 views4 answers
Drop primary key
SQL
0 vote245 views1 answer
Two inner joins sql
SQL
0 vote167 views1 answer
Sub blocks in sql
SQL
14 votes188 views5 answers
Set password for postgres user ubuntu
SQL
0 vote187 views1 answer
Sql server change schema of a table
SQL