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 vote131 views2 answers
Zsh: command not found: mysq
SQL
-1 vote139 views2 answers
Mysql get day of week
SQL
0 vote127 views1 answer
Oracle service name view
SQL
0 vote129 views1 answer
Access mysql database docker container shell
SQL
0 vote151 views2 answers
Sql if empty then
SQL
1 vote119 views1 answer
Sql server 2012 query history
SQL
0 vote126 views1 answer
Doesn't have default value mysql
SQL
1 vote98 views1 answer
What are the cursors and what are the cursors types? in sql
SQL
0 vote181 views1 answer
Mysql show foreign keys column
SQL
25 votes128 views6 answers
Sql update query
SQL