/SQL/How to add a Try/Catch to SQL Stored Procedure

How to add a Try/Catch to SQL Stored Procedure

 CREATE PROCEDURE [dbo].[PL_GEN_PROVN_NO1]        
       @GAD_COMP_CODE  VARCHAR(2) =NULL, 
       @@voucher_no numeric =null output 
       AS         
   BEGIN  

     begin try 
         -- your proc code
     end try

     begin catch
          -- what you want to do in catch
     end catch    
  END -- proc end

Source: stackoverflow.com

Similar codes

3 votes365 views1 answer
Oracle apex call duration
SQL
0 vote348 views1 answer
Mysql select last 15 minutes
SQL
0 vote354 views1 answer
How to get data between a last week in mysql
SQL
1 vote335 views1 answer
Find logged in users mysql
SQL
3 votes343 views1 answer
Oracle detect invalid password
SQL
1 vote358 views1 answer
Oracle add proxy
SQL
1 vote381 views2 answers
Postgres select from last 3 months
SQL
1 vote389 views1 answer
Update from table tsql
SQL
4 votes354 views1 answer
Create table if not exist in sqlite
SQL
0 vote351 views1 answer
Laravel general error 2006 mysql server has gone away
SQL