/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 vote189 views1 answer
Plsql check how much space all databases are consuming
SQL
1 vote165 views1 answer
SQL query to get all table records count from a database
SQL
1 vote180 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote168 views2 answers
Database owner can't create new tables postgres
SQL
0 vote163 views1 answer
Sql change default collation to utf8
SQL
2 votes185 views2 answers
How to add not null constraint in sql
SQL
0 vote247 views1 answer
Sql trigger to call stored procedure with parameters
SQL
0 vote152 views1 answer
Full syntax inner join
SQL
0 vote155 views1 answer
Sql injection mitigation
SQL
0 vote174 views1 answer
Drop view in mysql
SQL