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 vote261 views1 answer
C# datetime to sql server datetime
SQL
4 votes264 views2 answers
Mysql show indexes on table
SQL
0 vote266 views1 answer
Dapper run sql script with parameters
SQL
0 vote307 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
0 vote274 views1 answer
Docker open terminal mysql server
SQL
0 vote297 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
0 vote276 views1 answer
Oracle exchange subpartition
SQL
5 votes284 views2 answers
To date oracle
SQL
4 votes293 views5 answers
Get last query in codeigniter 4
SQL
0 vote275 views1 answer
Mysql filter based on datediff
SQL