/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

19 votes166 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
3 votes137 views2 answers
Sql server current date without time
SQL
1 vote137 views1 answer
Pv mysql import
SQL
0 vote156 views1 answer
SELECT statement to find the specific cell in database table
SQL
0 vote153 views2 answers
Postgres having
SQL
1 vote181 views1 answer
Ora-01950 no privileges on tablespace
SQL
0 vote150 views1 answer
Sql change column in existing table
SQL
2 votes93 views2 answers
Mysql get last character of string
SQL
2 votes147 views1 answer
SQL column name Postgre
SQL
-1 vote142 views1 answer
Auto increment psql not primary key
SQL