Please note, new blog at http://www.acheron.org/darryl/

SQL Server: Table variables vs. temporary tables

I just learned about table data types in SQL Server from some posts in the CFAUSSIE mailing list (via Scott Thornton). It looks like table data types are meant to replace temporary tables in SQL Server 2000, and have a very similar syntax. Temporary table CREATE TABLE #tmpTable(Col1 int, Col2 int) Table variable DECLARE @tmpTable TABLE(Col1 int, Col2 int) I did some searching, and one of the first results was this site. Interesting read, even though it was only the first part of a subscription only article. It turns out that table data types are slower than temporary tables for large sets of data, because SQL Server doesn't maintain statistics for queries on table variables.

By Blogger MayurSears,, at 8/31/2008 03:56:00 pm  

Visit for more details http://developmentzone.blogspot.com/2008/08/sql-server-temporary-tables.html



By Blogger MayurSears,, at 8/31/2008 03:57:00 pm  

Visit also http://developmentzone.blogspot.com/2008/08/temporary-tables-performance.html



By Blogger longge, at 6/26/2010 10:12:00 am  

You would become acclaimed in your acquisition just because of accustomed the best superior replica louis vuitton handbags
with you; these lv handbag
are accepting added popularity. Wherever you would go, these louis vuitton bag
would be taken as a attribute of chic and elegance.



By Blogger 太子, at 6/29/2010 01:38:00 pm  

hermes bag
are hand-built by awful accomplished craftsmen, one of the primary factors that contributes to the top amount of all Hermes Lindy
. The assembly of anniversary herme
can yield up to 48 hours of work.



Not alone do Chanel bag
attending abundant. Every anchorman Chanel Wallet
is issued its own hologram approval amount. This is the way to ensure that the Chanel handbags
that you accept purchased.



» Post a Comment

Trackbacks:

» Create a Link