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 vote125 views1 answer
Trim leading zeros in sql
SQL
0 vote126 views1 answer
PGSQL dynamic table name
SQL
0 vote112 views2 answers
Azure sql-datenbank
SQL
0 vote112 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote120 views1 answer
Mysqldump don't drop table
SQL
0 vote115 views1 answer
Search db for table name
SQL
0 vote111 views1 answer
Oracle list subpartitions
SQL
1 vote135 views2 answers
Remove space in mysql
SQL
0 vote130 views1 answer
Sql output select
SQL
0 vote60 views1 answer
FindAllBy
SQL