/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

0 vote297 views1 answer
Select 1 from orders
SQL
8 votes284 views3 answers
Mysql alter table add index
SQL
19 votes302 views5 answers
Date between in mysql
SQL
0 vote298 views1 answer
Mysqlcli how to load external sql file
SQL
4 votes300 views4 answers
Print pl sql
SQL
0 vote293 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
0 vote283 views1 answer
Price-colour
SQL
1 vote438 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
0 vote293 views1 answer
List all functions and procedures in postgres query
SQL
0 vote309 views1 answer
Closure in sql
SQL