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

1 vote191 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
0 vote159 views1 answer
Mysql workbench search all tables
SQL
0 vote207 views1 answer
Sqlite3 update select
SQL
0 vote320 views1 answer
Placements hackerrank solution
SQL
0 vote196 views1 answer
Postgres where
SQL
0 vote237 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
4 votes192 views1 answer
To date oracle with time
SQL
5 votes208 views3 answers
Sql max value in column
SQL
0 vote254 views1 answer
Mysql trigger to delete old data
SQL
0 vote190 views1 answer
First mysql
SQL