/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 vote301 views2 answers
Rebuild index sql server
SQL
2 votes325 views2 answers
Sqlalchemy filter or
SQL
0 vote310 views1 answer
Postgresql function ROUND
SQL
0 vote304 views1 answer
Mysql workbench indent formatting
SQL
3 votes332 views2 answers
Oracle sql first day of month
SQL
2 votes326 views1 answer
Sql server current date minus 5 years
SQL
0 vote305 views2 answers
Csv into data postgres
SQL
0 vote323 views1 answer
T sql dynamic top n query
SQL
0 vote318 views1 answer
Sql output select
SQL
0 vote298 views1 answer
Where case insensitive like mysql
SQL