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 vote143 views1 answer
Compare if is null sql
SQL
-1 vote149 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
11 votes136 views6 answers
Distinct sql
SQL
0 vote130 views1 answer
Sql count null as 0
SQL
4 votes161 views1 answer
Postgresql change default value
SQL
5 votes126 views3 answers
Sql max value in column
SQL
0 vote137 views1 answer
Guid string to binary better
SQL
0 vote159 views1 answer
Mysql grant user wildcard database
SQL
0 vote129 views1 answer
Postgresql stored procedure update table values
SQL
0 vote130 views1 answer
Postgresql delete type
SQL