Temporary Table vs Table Variable

Posted: January 18, 2007 in Uncategorized
Often you are into a SQL interview and you ll see a common Question When to use a temp table vs when to use a table variable and different variations to this often floated around in many Sql Invw Faqs.The SQL Programmability and API developement team  put a indepth post on this issue , one you should peek into.Here is the link http://blogs.msdn.com/sqlprogrammability/archive/2007/01/18/11-0-temporary-tables-table-variables-and-recompiles.aspx prior to this Jerry also had a indepth post with few good observation here http://jdixon.dotnetdevelopersjournal.com/tablevalued_variables.htm.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s