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

3 votes184 views1 answer
Créer une table sql
SQL
2 votes187 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
3 votes222 views1 answer
What is having
SQL
4 votes206 views1 answer
Rename stored procedure in sql server
SQL
17 votes183 views5 answers
Order by sql
SQL
0 vote178 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
0 vote190 views1 answer
Psql generate id in existing database
SQL
6 votes184 views2 answers
Difference between join vs union
SQL
14 votes226 views5 answers
Set password for postgres user ubuntu
SQL
0 vote179 views2 answers
Android sqlite tutorial for beginners
SQL