Rajanand Ilangovan
Rajanand Ilangovan

Rajanand Ilangovan

What happens to the variable value set during the transaction, if its rollback?

What happens to the variable value set during the transaction, if its rollback?

Rajanand Ilangovan's photo
Rajanand Ilangovan
·Mar 18, 2022·

1 min read

Question:

DECLARE @my_age INT = 20;

BEGIN TRAN
SET @my_age += 30;
ROLLBACK;

SELECT @my_age;

Answer:

Even though the transaction is rolled back, the value set to the variable remains same.

1117_20220406_003230.png

Changes to variables aren't affected by the rollback of a transaction.

Reference:
Microsoft docs
Brent Ozar

If you like this SQL interview question, you may also like the below interview question and answers.

Impressum