/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 vote179 views1 answer
Sql server system messeges
SQL
0 vote126 views2 answers
Drop check constraint in ms sql
SQL
0 vote141 views1 answer
C# execute transact sql
SQL
0 vote126 views1 answer
What is the use of index in mysql table
SQL
0 vote130 views2 answers
Postgres another version
SQL
11 votes124 views3 answers
How to get last row of table in sql
SQL
-1 vote123 views1 answer
How to switch user in mysql
SQL
1 vote122 views3 answers
Read all columns of a table sql
SQL
1 vote161 views1 answer
Drop colum oracle 18c
SQL
2 votes159 views1 answer
Sql server: select column values as comma separated string
SQL