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 vote195 views1 answer
How to find median of a column sql
SQL
0 vote194 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
1 vote201 views1 answer
Access the postgres psql
SQL
1 vote295 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote196 views1 answer
What are the aggregate function in sql
SQL
2 votes239 views1 answer
Oracle insert or update
SQL
4 votes214 views2 answers
Oracle drop job
SQL
0 vote238 views1 answer
Virtuoso sql query tutorial
SQL
0 vote213 views1 answer
Mysql return column names when table is empty
SQL
1 vote203 views1 answer
Set mysql mode global query
SQL