/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 vote204 views1 answer
Select from describe sql
SQL
0 vote221 views1 answer
How to create a new shema using query languaage
SQL
0 vote210 views1 answer
How to check which sp is running in sql server
SQL
1 vote242 views1 answer
Show databases mysql docker
SQL
0 vote234 views1 answer
Mysql select random rows large table
SQL
4 votes221 views1 answer
Datepart postgres
SQL
0 vote205 views1 answer
Joins vs includes
SQL
14 votes221 views2 answers
Oracle export trigger ddl
SQL
0 vote217 views1 answer
C# select Mysql
SQL
-1 vote220 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL