/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

3 votes187 views2 answers
Laravel tosql with bindings
SQL
0 vote173 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
1 vote188 views2 answers
How to drop a unique constraint in sql
SQL
1 vote179 views1 answer
Woocommerce mysql price table
SQL
0 vote196 views1 answer
How to find all children of a record with only parent ID in sql
SQL
0 vote198 views2 answers
List all constraints in postgres
SQL
0 vote181 views1 answer
Sql server udf performance
SQL
10 votes273 views4 answers
Sql server pagination
SQL
1 vote137 views1 answer
Mssql string length
SQL
1 vote178 views1 answer
T-sql find object by name
SQL