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

8 votes212 views1 answer
Oracle find text in functions
SQL
1 vote206 views1 answer
Mysql find tables with column name
SQL
10 votes230 views2 answers
Mysql alter add foreign key
SQL
150 votes368 views10 answers
Grepper
SQL
0 vote200 views2 answers
Change database postgres
SQL
0 vote223 views1 answer
Migrations.RunSQL
SQL
0 vote220 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote217 views1 answer
Alter owner in PostgreSQL
SQL
0 vote246 views1 answer
Mysql 3 months ago
SQL
0 vote262 views1 answer
How to find unique element in sql
SQL