/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

1 vote292 views1 answer
Oracle previous year
SQL
0 vote301 views2 answers
Mysql update two tables at once
SQL
-1 vote303 views3 answers
Error: mysql shutdown unexpectedly.
SQL
26 votes283 views2 answers
Mysql workbench download
SQL
7 votes350 views2 answers
Drop index oracle
SQL
0 vote313 views2 answers
How to install psql in ubuntu
SQL
1 vote291 views3 answers
How to update column name in psql
SQL
0 vote303 views1 answer
Create synonym for dblink in oracle
SQL
0 vote284 views1 answer
Sql select random procentage from rows
SQL
51 votes470 views6 answers
Opera gx
SQL