/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 vote275 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
1 vote246 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote258 views1 answer
How to use lower case in mysql
SQL
5 votes285 views1 answer
How to get all table names in sql query
SQL
0 vote298 views1 answer
Mysql faster delete
SQL
0 vote273 views1 answer
Clear query cache sql server
SQL
2 votes271 views1 answer
How to find constraints on a table in oracle
SQL
0 vote281 views1 answer
Oracle list datafiles
SQL
3 votes279 views2 answers
How to open postgresql in windows
SQL
2 votes285 views2 answers
Sqlalchemy return id after insert
SQL