/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 vote112 views1 answer
Copying query result to excel
SQL
8 votes136 views3 answers
Find table for column name in sql
SQL
0 vote118 views1 answer
Sql get year from datetime field
SQL
0 vote102 views1 answer
Min mysql
SQL
0 vote124 views1 answer
Disable database droping sql
SQL
2 votes131 views1 answer
Revokeprivileges mysql
SQL
1 vote109 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
4 votes116 views2 answers
Oracle sql group by date year
SQL
17 votes122 views3 answers
How to change a collumn name in sql
SQL
17 votes107 views4 answers
Sort by mysql
SQL