/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 votes125 views2 answers
Postgres select duplicate columns
SQL
0 vote134 views1 answer
Oracle running queries sql
SQL
0 vote132 views1 answer
Ansi sql count duplicate rows
SQL
0 vote133 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote119 views1 answer
Change data type in mysql
SQL
0 vote192 views2 answers
Fanyi
SQL
-1 vote148 views4 answers
Postgres between dates
SQL
0 vote119 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote131 views2 answers
Mysql dump database tables only
SQL
1 vote129 views1 answer
Postgresql can you have null foreign key
SQL