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 vote114 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote101 views1 answer
Json_remove mysql
SQL
1 vote112 views1 answer
Convert epoch to date in sql server
SQL
0 vote116 views3 answers
Sql server import json
SQL
2 votes89 views1 answer
Mysql auto increment jumping
SQL
0 vote116 views1 answer
Mysql url data type
SQL
3 votes107 views1 answer
Increment integer in table sql
SQL
1 vote148 views1 answer
Psql client write to bash variable
SQL
0 vote112 views1 answer
Find wordpress version in database
SQL
1 vote99 views1 answer
Sqlite create index
SQL