/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

7 votes348 views3 answers
Convert ansi sql
SQL
26 votes335 views2 answers
Mysql workbench download
SQL
0 vote363 views2 answers
Execute stored procedure without db set
SQL
1 vote334 views1 answer
Postgres start database on linux
SQL
17 votes332 views3 answers
Cast in sql server
SQL
9 votes361 views1 answer
Alter table column change data type to text mysql
SQL
0 vote330 views1 answer
Restart sql server command line linux
SQL
-2 votes343 views2 answers
Union vs union all in sql
SQL
4 votes368 views1 answer
Sql delete multiple conditions
SQL
0 vote331 views2 answers
Demmarrer un service mysql teminal cmd
SQL