/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 vote113 views1 answer
If column value is null then in mysql
SQL
0 vote102 views1 answer
Alasql delete column
SQL
0 vote94 views1 answer
Running query in redshift
SQL
0 vote96 views1 answer
Output table plsql
SQL
3 votes122 views1 answer
Oracle function return
SQL
2 votes124 views1 answer
Brew start postgres manual
SQL
1 vote107 views1 answer
Sql drop with dependencies
SQL
0 vote106 views1 answer
Connect postgresql using a connection string
SQL
0 vote108 views1 answer
Sql select min
SQL
0 vote103 views1 answer
Column ' ' in field list is ambiguous
SQL