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

3 votes331 views1 answer
Oracle user quota on tablespace
SQL
2 votes338 views1 answer
When matched in sql server
SQL
1 vote286 views1 answer
Into sql
SQL
2 votes340 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote340 views1 answer
Sqlite to csv statement
SQL
0 vote321 views1 answer
Sql where time stamp is in between
SQL
0 vote344 views1 answer
Distinct data types in a table sql query
SQL
0 vote383 views1 answer
Mysql sum per week
SQL
1 vote340 views1 answer
Python escape mysql
SQL
2 votes330 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL