October 5, 2013 at 11:51 am
Comments posted to this topic are about the item What happens to a variable after COMMIT or ROLLBACK
October 5, 2013 at 12:03 pm
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.
October 5, 2013 at 4:26 pm
October 6, 2013 at 12:20 pm
good question
October 6, 2013 at 2:26 pm
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
October 6, 2013 at 10:59 pm
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/
October 6, 2013 at 11:01 pm
Nice and Easy Question to start the week.
🙂
October 6, 2013 at 11:18 pm
Mr. Kapsicum (10/6/2013)
Nice and Easy Question to start the week.🙂
+2
October 7, 2013 at 1:11 am
Too much easy!
Thanks for TWO free points.
October 7, 2013 at 1:37 am
Carlo Romagnano (10/7/2013)
Too much easy!Thanks for TWO free points.
+2
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
October 7, 2013 at 1:42 am
PRR.DB (10/6/2013)
Mr. Kapsicum (10/6/2013)
Nice and Easy Question to start the week.🙂
+2
+3 🙂
October 7, 2013 at 1:55 am
Easy one. Thanks.
October 7, 2013 at 2:52 am
This was removed by the editor as SPAM
October 7, 2013 at 3:40 am
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
October 7, 2013 at 6:38 am
Thank you for this morning's brain warm-up.
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply