/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

1 vote354 views2 answers
Sql insert timestamp
SQL
0 vote316 views1 answer
Sql insert tuple
SQL
0 vote318 views3 answers
Group_concat sql server
SQL
0 vote323 views1 answer
Regex mongoose
SQL
0 vote334 views1 answer
Postgresql delete limit
SQL
3 votes318 views1 answer
Ssh check mysql version
SQL
0 vote333 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
0 vote333 views1 answer
Mysql select inside sum
SQL
1 vote319 views3 answers
Reset sql primary key
SQL
10 votes315 views2 answers
Reset mysql root password mac
SQL