September 28, 2009 at 4:58 am
Does temporary table and table variable can use all the database data types that a normal table can hold?
-lk
September 28, 2009 at 5:07 am
No differences at all as far as I have ever found.
Mike
September 28, 2009 at 6:03 am
As mentioned already, they are the same as regards to what data type are allowed.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 28, 2009 at 6:13 am
Scope is limited for temptables and Temp variable.
September 29, 2009 at 1:25 am
If you use user defined types (UDT), you must register the UDT in the tempdb before they will be available to your temp table.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply