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 vote209 views1 answer
Oracle sql number to varchar2
SQL
0 vote197 views1 answer
Postgres sql alter table delete row
SQL
0 vote255 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
1 vote223 views1 answer
Dropping a constraint in ms sql
SQL
1 vote231 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote198 views1 answer
Mysql remove tabs from string
SQL
1 vote163 views1 answer
Mysql see column types
SQL
0 vote168 views1 answer
Mysqli or pdo
SQL
2 votes261 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote217 views1 answer
Code to move ietms from one table to another myswl
SQL