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

12 votes316 views3 answers
Install sqlite driver ubuntu
SQL
4 votes308 views1 answer
Refresh postgres config
SQL
-1 vote363 views1 answer
How to Activate the database
SQL
0 vote282 views1 answer
Mysql workbench search all tables
SQL
0 vote282 views1 answer
Ms sql unique
SQL
0 vote321 views1 answer
Check if a column is a primary key in sql server
SQL
3 votes288 views1 answer
Make a field auto_increment mysql
SQL
3 votes310 views4 answers
Stop MySQL
SQL
13 votes319 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
1 vote307 views1 answer
Psql client write to bash variable
SQL