/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 vote182 views1 answer
Sql clear table
SQL
3 votes198 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote190 views1 answer
Sqlalchemy get schema from database
SQL
18 votes183 views3 answers
Mysql add column default value
SQL
11 votes198 views3 answers
Python sqlite3 create table if not exists
SQL
2 votes180 views1 answer
Mysql query unique column
SQL
-1 vote178 views2 answers
How to select the lowest values from table per client sql
SQL
12 votes168 views3 answers
Duplicate a column in sql
SQL
0 vote205 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
1 vote264 views1 answer
Mysql get max value and id
SQL