/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 vote173 views1 answer
Create dabase postgresql
SQL
6 votes157 views1 answer
Postgresql add enum value
SQL
1 vote147 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
0 vote154 views1 answer
Linked server delete openquery
SQL
49 votes250 views6 answers
Install mysql ubuntu
SQL
12 votes148 views4 answers
Mysql ifnull
SQL
10 votes144 views1 answer
Create table oracle
SQL
-1 vote178 views1 answer
Mysql delete duplicate rows except one
SQL
0 vote187 views1 answer
Start stop mysql linux
SQL
1 vote157 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL