/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 vote345 views1 answer
TSQL Find csv file in folder
SQL
1 vote305 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote303 views2 answers
Mysql dump database tables only
SQL
-2 votes274 views1 answer
Remove root password mysql
SQL
6 votes279 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote281 views3 answers
Mysql regex replace
SQL
6 votes260 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote302 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
1 vote256 views1 answer
Oracle start job
SQL
1 vote294 views1 answer
T-SQL / AZURE Reseed
SQL