SQLServerCentral

Update on differences in table types (temp/var/user)


https://www.sqlservercentral.com/Forums/Topic1491416.aspx

By Steve Jones - SSC Editor - Wednesday, September 4, 2013 3:27 AM

I'd like a short piece that explains the differences between temp tables, table variables, regular tables, user defined table types.

When to use each.
By GilaMonster - Wednesday, September 4, 2013 3:29 AM

If you don't mind waiting a few months, I can pick this one up.
By Steve Jones - SSC Editor - Wednesday, September 4, 2013 3:35 AM

that's fine. just not too many months.
By Jeff Moden - Wednesday, September 4, 2013 8:40 AM

Steve Jones - SSC Editor (9/4/2013)
I'd like a short piece that explains the differences between temp tables, table variables, regular tables, user defined table types.

When to use each.


What would you be looking for that Wayne Sheffield didn't include in his piece on the subject?
By Steve Jones - SSC Editor - Wednesday, September 4, 2013 11:51 AM

Perhaps not much. The UDTT isn't in there, but maybe something that more concisely shows some comparison code.

I'll think, but Wayne's article is a lot of discussion without a succinct comparison of where you might or might not use them. It's got lots of details, and is a reference I like, but I can see where it puts off someone just trying to make a decision of whether one is better than the other.
By Steve Jones - SSC Editor - Friday, January 31, 2014 4:02 AM

bump. anyone want to give a quick 1-2 pager on this?
By Steve Jones - SSC Editor - Thursday, June 1, 2017 7:14 AM

tychopotts - Thursday, June 1, 2017 11:09 AM
I can handle this if you're still looking for a comprehensive write-up.


Take it
By Steve Jones - SSC Editor - Tuesday, June 6, 2017 8:00 AM

Thanks, closing for now.
By tychopotts - Tuesday, June 6, 2017 6:42 AM

I have submitted my draft for this. Thanks for letting me take a stab at this.
By tychopotts - Thursday, June 1, 2017 4:09 AM

I can handle this if you're still looking for a comprehensive write-up.