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 votes272 views4 answers
Mysql create table from select statement
SQL
0 vote271 views1 answer
How to remove default in mysql
SQL
0 vote298 views1 answer
Plpgsql raise notice
SQL
1 vote270 views1 answer
Import database from a file using mysql commandline
SQL
1 vote303 views1 answer
How to use db.execute
SQL
0 vote315 views2 answers
Temp tables in sql server
SQL
16 votes286 views6 answers
Mysql find and replace
SQL
0 vote293 views1 answer
Sql stored procedure update if parameter is not null
SQL
-1 vote294 views1 answer
Mysql case when multiple conditions
SQL
1 vote298 views1 answer
How to test for sql injection
SQL