What happens to a variable after COMMIT or ROLLBACK
-
Comments posted to this topic are about the item What happens to a variable after COMMIT or ROLLBACK
-
Nice idea, this question!
SQL Server writes only changed data pages, not variables. That concept in mind forbids any other answer, doesn't it?
________________________________________________________
If you set out to do something, something else must be done first. -
good question
-
Very nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
bitbucket-25253 (10/5/2013)
A very back to basics question ...... Thanks+1
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/ -
Nice and Easy Question to start the week.
-
Mr. Kapsicum (10/6/2013)
Nice and Easy Question to start the week.+2
-
Too much easy!
Thanks for TWO free points.
-
Carlo Romagnano (10/7/2013)
Too much easy!Thanks for TWO free points.
+2
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant -
PRR.DB (10/6/2013)
Mr. Kapsicum (10/6/2013)
Nice and Easy Question to start the week.+2
+3
-
Easy one. Thanks.
-
Thanks for the question!
It might be good also to point that table variables are not affected either by transaction rollbacks.
As per BOL
Because table variables have limited scope and are not part of the persistent database, they are not affected by transaction rollbacks.
http://technet.microsoft.com/en-us/library/ms175010.aspx
Cheers
-
Thank you for this morning's brain warm-up.
-
Thanks to OP for submitting the question. Still scratching my head about it being worth two points. But, I'll take them.
They put me that much closer to having enough points to retire.
[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply