/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

32 votes124 views6 answers
Insert into values select
SQL
13 votes117 views2 answers
Get tables in database sql
SQL
9 votes113 views4 answers
SQL Date Format
SQL
2 votes112 views1 answer
Set username and password for postgresql database
SQL
1 vote141 views1 answer
Mysql return text after a final full stop
SQL
1 vote119 views1 answer
Postgresql can you have null foreign key
SQL
5 votes125 views1 answer
Get column name sql server
SQL
2 votes117 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
1 vote117 views1 answer
Postgresql not in
SQL
1 vote111 views2 answers
Mysql current user
SQL