/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 vote119 views1 answer
Setval pgsql
SQL
0 vote84 views1 answer
Sql query with date
SQL
0 vote112 views1 answer
Copy value from one column to another postgres
SQL
6 votes118 views1 answer
How to count number of rows in sql
SQL
1 vote121 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
0 vote115 views2 answers
Sql server select where date
SQL
0 vote113 views1 answer
Oracle synonym procedure
SQL
0 vote124 views3 answers
Sql server import json
SQL
46 votes123 views4 answers
Create column sql
SQL
0 vote111 views1 answer
How to print out column name differently in mysql
SQL