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 vote203 views1 answer
Copy Table from SQL to CSV
SQL
0 vote191 views1 answer
Psql store procedure-return multiple table values
SQL
0 vote215 views1 answer
Postgresql stored procedure update table values
SQL
11 votes194 views1 answer
Sql query to find duplicates in column
SQL
0 vote194 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
0 vote210 views1 answer
Dataframe lambda elif
SQL
7 votes201 views3 answers
Python and mysql connectivity
SQL
36 votes207 views6 answers
Delete from where sql
SQL
0 vote196 views1 answer
Mariadb number format
SQL
0 vote243 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL