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

2 votes130 views1 answer
Create table with primary key
SQL
3 votes230 views2 answers
Savepoint in sql
SQL
2 votes178 views1 answer
Sql server: select column values as comma separated string
SQL
8 votes166 views1 answer
Oracle tablespace datafile max size
SQL
8 votes215 views1 answer
Oracle search code in packages
SQL
0 vote151 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote141 views1 answer
1 column values in to 1 single row in sql
SQL
0 vote166 views1 answer
Oracle sql date winter time
SQL
0 vote167 views1 answer
Varchar format not case sensitive sql
SQL
0 vote204 views1 answer
Oracle db get table sizes
SQL