Temp tables in transaction

Question

Post reply

Temp tables in transaction

Sergiy

SSC Guru

Points: 110208
More actions
November 15, 2016 at 10:07 pm

#323000

Comments posted to this topic are about the item Temp tables in transaction
_____________
Code for TallyGenerator
November 16, 2016 at 12:10 am

This was removed by the editor as SPAM

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 1

A good reminder QotD. Thanks.

Igor Micev,My blog: www.igormicev.com

Ed Wagner SSC Guru Points: 287026 More actions · Answer 2

Good question, Sergiy. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 3

akljfhnlaflkj

SSC Guru

Points: 76202

November 16, 2016 at 6:57 am

#1912774

Thanks for the question.

Sean Lange SSC Guru Points: 286590 More actions · Answer 4

Nice straight forward question Sergiy. And something that many people don't know.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

MMartin1 One Orange Chip Points: 27795 More actions · Answer 5

Good QotD. Someone not knowing this could introduce a serious bug into their work.

----------------------------------------------------

Ed Wagner SSC Guru Points: 287026 More actions · Answer 6

There are all kinds of interesting tidbits about table variables and temp tables. Wayne Sheffield has a great presentation on them that I really enjoyed. I'd recommend attending if anyone gets an opportunity.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Revenant SSC-Forever Points: 42467 More actions · Answer 7

Revenant

SSC-Forever

Points: 42467

November 16, 2016 at 3:52 pm

#1912930

Very good, Sergiy - thanks you!

Sergiy SSC Guru Points: 110208 More actions · Answer 8

Thanks everyone for positive feedbacks.

For myself I use a simple rule of thumb here:

table is a table, even if it's a temporary one, and within transactions it acts as a table;

variable is a variable, even if it's a table type one, and within transactions it acts as all variables.

_____________
Code for TallyGenerator

TomThomson SSC Guru Points: 104773 More actions · Answer 9

Nice question. And I like that simple rule of thumb.

Managed to get it wrong by clicking as I pushed the mouse up the screen and timed the click wrong. I must be getting old and decrepit or something, obviously that sort of slip could lose a life in games that I used to play when I was much younger.

Tom

Junior Galvão - MVP SSCertifiable Points: 6930 More actions · Answer 10

Hy Sergiy,

I performed this code on SQL Server 2016 Express and result show the both tables dont have records.

Please test this code on SQL Server 2016 Express.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 11

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP