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 vote130 views1 answer
Set mysql socket file docker windows
SQL
1 vote136 views1 answer
Sql how to replace full stop
SQL
103 votes289 views1 answer
Like sql
SQL
0 vote138 views1 answer
Limit in access query
SQL
3 votes123 views1 answer
Postgres kill running query
SQL
0 vote122 views1 answer
Recover deleted data from mysql database
SQL
0 vote132 views1 answer
Enable sql server full text indexing
SQL
11 votes155 views2 answers
Set default column value sql
SQL
1 vote110 views1 answer
Table infromation in sql server
SQL
0 vote132 views3 answers
Sql delete all except
SQL