/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 vote220 views1 answer
Export mysql table to file
SQL
0 vote228 views1 answer
How to install mysql without admin rights
SQL
0 vote317 views1 answer
Restart serial number for postgres
SQL
0 vote184 views1 answer
Mysql convert column to uppercase
SQL
8 votes252 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote209 views1 answer
Oracle list chain steps
SQL
0 vote225 views1 answer
Export partttion and import in oracle
SQL
0 vote230 views2 answers
SQL BULK INSERT
SQL
-1 vote221 views1 answer
MYSQL stored procedure select from
SQL
0 vote257 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL