/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 vote176 views1 answer
Join first name and last name sql
SQL
0 vote188 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote185 views1 answer
List mysql tables and views
SQL
0 vote175 views1 answer
Stored procedures example
SQL
0 vote207 views1 answer
Local pg_sql to heroku pg_sql
SQL
1 vote187 views1 answer
Select users with same username
SQL
0 vote224 views1 answer
Postgresql create table default value timestamp
SQL
0 vote250 views1 answer
Selecting specific day in colum sql
SQL
5 votes167 views1 answer
Sql first day of current year
SQL
0 vote196 views1 answer
Mysql 5.6 hierarchical recursive query
SQL