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 vote231 views1 answer
Test database for sql
SQL
1 vote235 views1 answer
Get last week data in mysql
SQL
0 vote252 views1 answer
MySQL - Enabling the Event Scheduler
SQL
2 votes242 views1 answer
Oracle sql merge
SQL
0 vote234 views1 answer
How to check xampp mysql password
SQL
5 votes231 views1 answer
Oracle list functions
SQL
0 vote225 views1 answer
Sql server separar numeros por comas miles
SQL
0 vote226 views1 answer
Add alternate add column sql
SQL
0 vote224 views1 answer
Replace content value from old to new sql
SQL
2 votes216 views1 answer
Sql ignore accents
SQL