/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 vote248 views1 answer
Order child below the parent in mysqli
SQL
0 vote242 views1 answer
Select insert new table sql server
SQL
0 vote236 views1 answer
Run mssql server terminal
SQL
0 vote230 views1 answer
Syntax for changing column size in mysql
SQL
1 vote253 views1 answer
SQL Integer devision
SQL
1 vote240 views1 answer
Mysql show long running queries
SQL
1 vote226 views1 answer
Funzioni plsql
SQL
11 votes239 views1 answer
Oracle view ddl
SQL
0 vote223 views1 answer
Json_remove mysql
SQL
1 vote225 views2 answers
Reset mysqli fetch_arra
SQL