/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 vote138 views1 answer
How to use update trigger in sql
SQL
8 votes162 views1 answer
Show mysql user table
SQL
1 vote143 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote299 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote132 views1 answer
Sub blocks in sql
SQL
0 vote162 views1 answer
Oracle execute immediate quotes
SQL
1 vote134 views1 answer
How to use a trigger to validate input data
SQL
0 vote147 views1 answer
Sql get number of days between two dates
SQL
0 vote166 views1 answer
Mysql aspas simples
SQL
0 vote138 views1 answer
Install mysql for fedora 34
SQL