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 vote319 views1 answer
Ora 00001 error catch plsql
SQL
0 vote371 views1 answer
PGSQL dynamic table name
SQL
35 votes338 views6 answers
Postgres
SQL
0 vote338 views1 answer
Get db connection detail from sql developer profile
SQL
8 votes364 views2 answers
How to fetch data from database without last column
SQL
1 vote375 views1 answer
Last 24 HOUR data in mysql
SQL
0 vote347 views1 answer
Faire une recherche par liste de mot clé sql
SQL
0 vote320 views1 answer
How to check default value of column in sql server
SQL
0 vote320 views1 answer
Postgresql log
SQL
3 votes329 views1 answer
Dbms_scheduler drop_job
SQL