Breaking News: Grepper is joining You.com. Read the official announcement!

try catch sql transaction

Add Answer

ekkamrit answered on July 9, 2021 Popularity 9/10 Helpfulness 8/10

answer try catch sql transaction

related sql try catch

related try catch sql

try catch sql transaction

Comment

BEGIN TRANSACTION [Tran1]            
BEGIN TRY           
-- sql statements(update/insert...)     
COMMIT TRANSACTION [Tran1]      
END TRY      
      
BEGIN CATCH      
ROLLBACK TRANSACTION [Tran1]      
SELECT ERROR_MESSAGE() AS ErrorMessage;      
END CATCH

Popularity 9/10 Helpfulness 8/10 Language sql

Source: Grepper

Tags: sql try-catch

Link to this answer
Share Copy Link

Contributed on Sep 28 2022

ekkamrit

0 Answers Avg Quality 2/10

Closely Related Answers

sql try catch

Comment

BEGIN TRY
  SELECT 1 / 0 AS Error;
END TRY
BEGIN CATCH
  SELECT
    ERROR_NUMBER() AS ErrorNumber,
    ERROR_STATE() AS ErrorState,
    ERROR_SEVERITY() AS ErrorSeverity,
    ERROR_PROCEDURE() AS ErrorProcedure,
    ERROR_LINE() AS ErrorLine,
    ERROR_MESSAGE() AS ErrorMessage;
END CATCH;

Popularity 10/10 Helpfulness 9/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jul 09 2021

Code with bulbul

0 Answers Avg Quality 2/10

try catch sql

Comment

# SQL Server
# Execute the query in try block
BEGIN TRY
  DECLARE @result FLOAT;
  SET @result = 1/0;
  SELECT @result;
END TRY
# Specify what to return if an exception is occurred in the try block
BEGIN CATCH
  SELECT 'Error occurred: ' + ERROR_MESSAGE();
END CATCH
# --------------------------------------------------------------------
# MySQL
BEGIN
  DECLARE result FLOAT;

  BEGIN
    # Execute the query in try block
    SET result = 1/0;
  EXCEPTION
    # Specify what to return if an exception is occurred in the try block
    WHEN DIVISION_BY_ZERO THEN
      SELECT 'Error occurred: Division by zero';
  END;
END;
# --------------------------------------------------------------------
# PostgreSQL
DO $$
BEGIN
  DECLARE result FLOAT;

  BEGIN
    # Execute the query in try block
    result := 1/0;
  EXCEPTION
    # Specify what to return if an exception is occurred in the try block
    WHEN division_by_zero THEN
      RAISE EXCEPTION 'Error occurred: Division by zero';
  END;
END $$;

Popularity 9/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: sql try-catch try-catc

Link to this answer
Share Copy Link

Contributed on Feb 18 2023

Innocent Iguana

0 Answers Avg Quality 2/10

try catch sql

Comment

-- It is Transaction Control Language(TCL)
-- case1 (temporary)
BEGIN TRANSACTION
-- perform DML operation i.e. INSERT, UPDATE, DELETE
ROLLBACK -- goes to previous state 

-- case2 (permanent)
BEGIN TRANSACTION
-- perform DML operation i.e. INSERT, UPDATE, DELETE
COMMIT -- Transaction is executed and hence change is done permanently

Popularity 9/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Aug 17 2022

ekkamrit

0 Answers Avg Quality 2/10

try catch sql transaction

Contents

More Related Answers

try catch sql transaction

Closely Related Answers

sql try catch

try catch sql

try catch sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.