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 vote141 views1 answer
What are the aggregate function in sql
SQL
0 vote173 views1 answer
Drop index in sql
SQL
0 vote164 views1 answer
Rabbitmq ui not working
SQL
0 vote162 views1 answer
Except in sql alchemy
SQL
7 votes151 views4 answers
How to reset the identity column in sql server
SQL
0 vote189 views1 answer
SQL-Arten
SQL
1 vote148 views3 answers
Execute sp in sql server
SQL
4 votes163 views2 answers
Bulk kill mysql processlist
SQL
0 vote167 views1 answer
Creating h2 database in relative directory eclopse
SQL
0 vote153 views2 answers
T SQl Checking Your Username
SQL