<h2 id="heading-question">Question:</h2>
<pre><code>DECLARE @my_age INT = 20;

BEGIN TRAN
SET @my_age += 30;
ROLLBACK;

SELECT @my_age;
</code></pre><h2 id="heading-answer">Answer:</h2>
Even though the transaction is rolled back, the value set to the variable remains same.
<img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1649185831120/2u9WEhnbc.png" alt="1117_20220406_003230.png" />
<blockquote>
Changes to variables aren't affected by the rollback of a transaction.
</blockquote>
Reference: <a target="_blank" href="https://docs.microsoft.com/en-us/sql/t-sql/language-elements/variables-transact-sql">Microsoft docs</a> <a target="_blank" href="https://twitter.com/BrentO/status/1296117565823934464">Brent Ozar</a>
If you like this SQL interview question, you may also like the below interview question and answers.
<ul>
<li><a target="_blank" href="https://blog.rajanand.org/how-to-calculate-total-travel-hours-between-city-x-and-y-and-vice-versa">How to do reciprocal in SQL?</a></li>
<li><a target="_blank" href="https://blog.rajanand.org/how-to-generate-permutations-in-sql">How to generate permutations in SQL?</a></li>
<li><a target="_blank" href="https://blog.rajanand.org/how-to-find-an-account-balance-in-sql">How to find account balance (running total) in SQL?</a></li>
<li><a target="_blank" href="https://blog.rajanand.org/what-happens-to-the-records-inserted-into-a-table-variable-if-the-transaction-rollback">What happens to the records inserted into a table variable, if the transaction rollback?</a></li>
</ul>

## 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](https://cdn.hashnode.com/res/hashnode/image/upload/v1649185831120/2u9WEhnbc.png)

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

Reference:  
[Microsoft docs](https://docs.microsoft.com/en-us/sql/t-sql/language-elements/variables-transact-sql)  
[Brent Ozar](https://twitter.com/BrentO/status/1296117565823934464)

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

- [How to do reciprocal in SQL?](https://blog.rajanand.org/how-to-calculate-total-travel-hours-between-city-x-and-y-and-vice-versa)
- [How to generate permutations in SQL?](https://blog.rajanand.org/how-to-generate-permutations-in-sql)
- [How to find account balance (running total) in SQL?](https://blog.rajanand.org/how-to-find-an-account-balance-in-sql)
- [What happens to the records inserted into a table variable, if the transaction rollback?](https://blog.rajanand.org/what-happens-to-the-records-inserted-into-a-table-variable-if-the-transaction-rollback)



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

I'm a Business Intelligence Developer with over a decade of experience in design and development of databases, data warehouse, ETL, business intelligence reports and data visualization/analytics.


I am a Business intelligence lead with over a decade of experience in building DW/BI solutions. I am a Microsoft Certified Solutions Expert in Data management &amp; analytics and trainer.

Rajanand's Blog

Rajanand's Blog

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

Question:

Answer: