/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

1 vote311 views1 answer
Unique vs distinct sql
SQL
2 votes377 views2 answers
Calculate percentage in sql
SQL
0 vote383 views1 answer
Delete a temporary table mysql
SQL
0 vote371 views1 answer
Count columns psql(PostreSQL)
SQL
0 vote343 views1 answer
Alter owner in PostgreSQL
SQL
0 vote330 views2 answers
Postgresql create role
SQL
0 vote342 views1 answer
Kotlin sqlite delete row
SQL
2 votes359 views1 answer
Codeigniter print last sql query
SQL
0 vote347 views1 answer
Copy Table from SQL to CSV
SQL
0 vote336 views1 answer
Retornar apenas o ano mysql date
SQL