/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

4 votes201 views2 answers
Xampp mysql database server is not starting mac m1
SQL
12 votes231 views1 answer
Run mysql instance in docker
SQL
0 vote207 views1 answer
Import sql inside hide sql
SQL
0 vote211 views1 answer
Postgres get database encoding
SQL
18 votes200 views2 answers
Sql inner join
SQL
0 vote214 views2 answers
Functions with parameters SQL
SQL
5 votes218 views1 answer
How to get all dates in a month in oracle
SQL
0 vote205 views1 answer
Mysql command line ubuntu
SQL
4 votes175 views1 answer
Install postgres 12 on ubuntu
SQL
18 votes213 views3 answers
Mysql add column default value
SQL