/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

23 votes176 views4 answers
Uninstall postgresql ubuntu
SQL
10 votes167 views2 answers
Rtrim sql
SQL
1 vote157 views2 answers
Mysql join two tables
SQL
0 vote151 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote335 views1 answer
Why do we need data structure in sql
SQL
-2 votes256 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote151 views1 answer
Sqlite select split string
SQL
0 vote157 views1 answer
Postgres statistics
SQL
8 votes148 views2 answers
Select table column name in sql
SQL
2 votes151 views2 answers
Sqlalchemy filter or
SQL