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 vote134 views1 answer
Greater than or equal to symbol in postgres
SQL
2 votes142 views2 answers
Laravel query builder toSql
SQL
1 vote156 views1 answer
Oracle user last connection date
SQL
0 vote142 views1 answer
Trigger vérifier stock
SQL
4 votes144 views1 answer
W3schools create table
SQL
0 vote146 views1 answer
Sql select column name like from multiple tables
SQL
0 vote137 views1 answer
Update top 100 order by sql server
SQL
2 votes162 views3 answers
Application.properties spring boot mysql
SQL
0 vote148 views1 answer
Creating a simple notify in postgresql
SQL
1 vote143 views1 answer
Increase existing date in sql
SQL