September 29, 2010 at 12:32 am
Hi all,
How to create dynamic or tempary table in sql server 2005
regards
pols
September 29, 2010 at 4:11 am
CREATE TABLE #table1
(
columns....
)
or
DECLARE @table2 TABLE
(
columns...
)
September 29, 2010 at 4:25 am
Search
temporary tables
in http://msdn.microsoft.com/en-us/library/ms174979.aspx and you can also use table variable.
Another useful link http://www.sql-server-performance.com/articles/per/temp_tables_vs_variables_p1.aspx and http://blogs.msdn.com/b/sqlserverstorageengine/archive/2008/03/30/sql-server-table-variable-vs-local-temporary-table.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 29, 2010 at 6:38 am
What are you trying to do? There are ways to create temporary tables (as is shown above), table variables, and you can create permanent tables, all on the fly. So you'll get better help if you describe the situation you're trying to support.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply