/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 vote172 views2 answers
Pl sql auto increment
SQL
0 vote398 views1 answer
Power bi connect to postgresql
SQL
0 vote179 views1 answer
Postgres can integer fields be negative
SQL
0 vote206 views1 answer
Oracle list dblink
SQL
1 vote179 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
4 votes167 views4 answers
What is primary key
SQL
0 vote183 views1 answer
Alter rename command in mysql
SQL
1 vote190 views1 answer
Mysql how to truncate table with foreign keys
SQL
20 votes159 views1 answer
Get all table name in sql through php
SQL
0 vote189 views1 answer
Sql new line output
SQL