/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 vote361 views1 answer
Hotw to alter lengh character vayng postgres
SQL
0 vote363 views3 answers
Sql server import json
SQL
0 vote360 views1 answer
Select insert new table sql server
SQL
6 votes378 views2 answers
Mysql execute file
SQL
5 votes376 views1 answer
Oracle asynchronous update
SQL
0 vote341 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
0 vote334 views1 answer
Truncate table sql server foreign key
SQL
4 votes372 views2 answers
Postgresql default value
SQL
0 vote336 views1 answer
Sqlalchemy query return only n results
SQL
3 votes365 views1 answer
Sql replace character in string in all records
SQL