/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

2 votes175 views1 answer
Tcl in sql
SQL
0 vote127 views1 answer
Sql where time stamp is in between
SQL
0 vote224 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote127 views1 answer
Postgresql create table default value timestamp
SQL
0 vote136 views1 answer
Change filed order in mysql
SQL
0 vote153 views1 answer
Cube oracle
SQL
0 vote150 views1 answer
Mariadb change column type
SQL
2 votes167 views3 answers
Postgres create view
SQL
0 vote142 views1 answer
Sql stored procedure update if parameter is not null
SQL
1 vote137 views3 answers
Mysql disable foreign keys check
SQL