/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 vote207 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
0 vote187 views1 answer
Update one column from another column in same table
SQL
-1 vote190 views1 answer
Mysql coalesce
SQL
0 vote182 views1 answer
Mysql to get column name in database
SQL
0 vote207 views1 answer
Oracle insert single quote in string
SQL
7 votes221 views2 answers
Sql remove duplicates based on column
SQL
0 vote204 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
2 votes195 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote192 views1 answer
C# execute transact sql
SQL
0 vote208 views1 answer
Regex any word except sql
SQL