/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

2 votes309 views1 answer
Mysql create user with remote access
SQL
0 vote297 views1 answer
Sql convert unix time to date
SQL
-1 vote286 views1 answer
Su: Authentication failure mysql
SQL
1 vote285 views3 answers
Rename table snowflake
SQL
1 vote268 views1 answer
Sql get all columns from one table but one from another inner join
SQL
0 vote297 views1 answer
Database xml sql
SQL
0 vote301 views2 answers
Functions with parameters SQL
SQL
0 vote312 views1 answer
How do you insert boolean to postgresql
SQL
0 vote306 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
0 vote337 views2 answers
Suse Linux restart MySQL
SQL