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 votes271 views2 answers
Postgres inner join vs join
SQL
0 vote252 views1 answer
Sql find table by name
SQL
0 vote251 views1 answer
Sql query interview questions githu
SQL
12 votes259 views4 answers
Import mysql database command line linux
SQL
1 vote261 views1 answer
Data type and their numeric form
SQL
0 vote250 views1 answer
Sql count total by foreign key
SQL
0 vote214 views1 answer
Calculate discount from original price sql
SQL
0 vote259 views1 answer
Sql server roles and users
SQL
6 votes263 views2 answers
Difference between join vs union
SQL
0 vote283 views2 answers
How to truncate all table in mysql workbench
SQL