/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 vote185 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote200 views1 answer
Sum value by month sql
SQL
1 vote195 views2 answers
Mysql allow remote connections
SQL
4 votes269 views2 answers
DB::transaction
SQL
5 votes205 views2 answers
Sql server check port number
SQL
0 vote168 views1 answer
Mysql timeout 30 seconds
SQL
0 vote215 views1 answer
Mysql root localhost run
SQL
0 vote208 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote203 views1 answer
Call rest api from postgresql
SQL
0 vote227 views1 answer
SELECT statement to find the specific cell in database table
SQL