/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 vote169 views1 answer
Mariadb hours between two dates
SQL
2 votes144 views1 answer
Where clause for child record apex
SQL
16 votes129 views1 answer
Sqlserver add column to table
SQL
0 vote153 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
0 vote181 views1 answer
Oracle create package specification
SQL
3 votes177 views1 answer
Query less than datetime sql
SQL
0 vote133 views1 answer
Sql inserted
SQL
0 vote140 views1 answer
Hive batch drop table
SQL
0 vote139 views1 answer
Sql server select value large text
SQL
2 votes138 views2 answers
Oracle multiple insert
SQL