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 votes176 views1 answer
Mysql set value as null
SQL
3 votes178 views1 answer
How to uninstall microsoft sql server
SQL
0 vote216 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote173 views2 answers
Postgres another version
SQL
9 votes184 views3 answers
Where clause sql
SQL
1 vote163 views1 answer
Mysql remove last empty newline
SQL
2 votes173 views1 answer
Mysql create user with remote access
SQL
0 vote167 views1 answer
Get first monday of month sql
SQL
0 vote193 views1 answer
Stratified sampling sql
SQL
0 vote173 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL