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 vote286 views1 answer
How to run sql script
SQL
2 votes349 views2 answers
Mysql show table column comments sql
SQL
25 votes391 views4 answers
Sqlserver add column
SQL
0 vote393 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote361 views1 answer
Sql select random procentage from rows
SQL
1 vote346 views1 answer
Oracle apex run 404
SQL
8 votes363 views1 answer
Oracle search code in packages
SQL
8 votes355 views1 answer
Declare table variable sql server
SQL
0 vote358 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
0 vote333 views1 answer
Mysql command prompt date insert format
SQL