/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

10 votes330 views1 answer
Oracle dba_dependencies
SQL
0 vote319 views2 answers
Update all columns in one update
SQL
-1 vote301 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
1 vote303 views1 answer
Load sql into mamp
SQL
0 vote294 views1 answer
Create column that already exists mysql
SQL
0 vote354 views1 answer
Check if mysql db is used
SQL
3 votes351 views3 answers
1396(hy00) mysql error
SQL
0 vote319 views1 answer
Drop constraint in ms sql
SQL
1 vote309 views1 answer
How to get mysql db size
SQL
2 votes304 views1 answer
Drop table if exists in postgres
SQL