/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 vote194 views1 answer
Sql update table remove spaces
SQL
14 votes256 views1 answer
Excel is not a database
SQL
1 vote206 views1 answer
Oracle create program if no exists
SQL
0 vote328 views1 answer
Mysql update all record removing 2 hours from column
SQL
6 votes198 views1 answer
Update left join mysql
SQL
1 vote272 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
0 vote150 views1 answer
How to see the content of tables in pgadmin
SQL
-1 vote193 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote186 views1 answer
Oracle list of long running queries
SQL
3 votes205 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL