/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 vote138 views1 answer
Create schema sql server
SQL
0 vote143 views1 answer
Uncomment listen_address=localhost
SQL
1 vote145 views3 answers
Mysql disable foreign keys check
SQL
0 vote151 views2 answers
Plsql function that return a table
SQL
5 votes181 views3 answers
Sql limit offset
SQL
16 votes178 views3 answers
Order by sql query
SQL
5 votes157 views1 answer
AND OR NOT operators sql
SQL
0 vote134 views1 answer
Acutal month year
SQL
0 vote160 views1 answer
Mysql get nth highest
SQL
0 vote100 views1 answer
How to connect sql server using ip address in c#
SQL