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

4 votes165 views2 answers
Mysql select where starts with
SQL
0 vote209 views1 answer
Sql cheetsheet
SQL
25 votes191 views6 answers
How to change column name in mysql
SQL
6 votes161 views4 answers
Sqlite drop table
SQL
7 votes284 views2 answers
Mysql default value
SQL
0 vote172 views2 answers
Zsh: command not found: mysq
SQL
0 vote247 views1 answer
Show mysql account privilleges
SQL
1 vote160 views1 answer
Sql trigger before delete
SQL
7 votes170 views2 answers
Add column table pl sql
SQL
1 vote133 views2 answers
Procedure pl/sql
SQL