Posted on • Originally published at blog.rajanand.org on
DECLARE @my_age INT = 20;
BEGIN TRAN
SET @my_age += 30;
ROLLBACK;
SELECT @my_age;
Even though the transaction is rolled back, the value set to the variable remains same.
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.
For further actions, you may consider blocking this person and/or reporting abuse
Node.js doesn’t stop from running other operations because of Libuv, a C++ library responsible for the event loop and asynchronously handling tasks such as network requests, DNS resolution, file system operations, data encryption, etc.
What happens under the hood when Node.js works on tasks such as database queries? We will explore it by following this piece of code step by step.
Emdadul Islam -
HassanHabibTahir -
aravind048 -
byby -
Once suspended, rajanand will not be able to comment or publish posts until their suspension is removed.
Once unsuspended, rajanand will be able to comment and publish posts again.
Once unpublished, all posts by rajanand will become hidden and only accessible to themselves.
If rajanand is not suspended, they can still re-publish their posts from their dashboard.
Once unpublished, this post will become invisible to the public and only accessible to rajanand ilangovan.
They can still re-publish the post if they are not suspended.
Thanks for keeping DEV Community safe. Here is what you can do to flag rajanand:
Unflagging rajanand will restore default visibility to their posts.
Top comments (0)