/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 vote263 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote261 views1 answer
Set Mamp mysql globally
SQL
0 vote261 views1 answer
Create table with float datatype in sql server
SQL
0 vote262 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
4 votes273 views1 answer
Data types in sql
SQL
1 vote272 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote256 views1 answer
Reona
SQL
1 vote247 views1 answer
Load sql into mamp
SQL
4 votes257 views1 answer
Oracle select first 10 rows
SQL
0 vote274 views1 answer
Query builder doctrien return sql
SQL