/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 vote408 views2 answers
Mysql insert rows to another database
SQL
0 vote411 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote362 views1 answer
SQL check if record exist
SQL
1 vote391 views1 answer
Sql first day quarter
SQL
0 vote340 views2 answers
Sql query in dax power bi
SQL
0 vote402 views2 answers
Check if sql temp table exists
SQL
0 vote364 views1 answer
Show tables in cassandra cql
SQL
4 votes321 views2 answers
Sql vs mysql
SQL
2 votes369 views2 answers
Calculate percentage in sql
SQL
0 vote343 views2 answers
Starting mysql service from mac
SQL