/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 vote165 views1 answer
Mssql describe stored procedure sqlcmd
SQL
13 votes204 views3 answers
List all the tables in sql
SQL
0 vote122 views1 answer
Expose db in virtualbox
SQL
0 vote168 views1 answer
Create column that already exists mysql
SQL
0 vote186 views1 answer
Typeorm raw sql
SQL
0 vote175 views1 answer
Search In the Data using ObjectName
SQL
1 vote162 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
5 votes164 views1 answer
Oracle asynchronous procedure
SQL
3 votes175 views1 answer
Postgresql if null then 0
SQL
0 vote185 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL