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 vote182 views1 answer
Microsoft sql server management studio clear cache
SQL
4 votes234 views3 answers
Sqlite show columns
SQL
0 vote239 views1 answer
How many rows affected in sqllite
SQL
6 votes244 views5 answers
Sql add months to date
SQL
1 vote237 views1 answer
Set autoincrement to 0
SQL
27 votes248 views3 answers
Mysql show tables in database
SQL
1 vote241 views1 answer
Mysql select from outside
SQL
0 vote232 views1 answer
Postgresql certain first 4 characters in string
SQL
0 vote228 views1 answer
Drop all data from tables
SQL
2 votes235 views1 answer
Creating a view SQL
SQL