Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Memory Table

Author  Topic 

pratikmehta
Starting Member

2 Posts

Posted - 2006-04-11 : 09:54:44
I want to create a memory based on existing table structure

like we use "select * into <new table name> from <old table name>" this will create new physycal table ,same like this i want to create new memory table.

is it possible?

Thanks

Pratik Mehta

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-04-11 : 09:59:19
Select * Into #temp From <TableName>

This will create the local temp tables, which after its scope gets over is automattically droped.

If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-04-11 : 10:05:52
What do you mean by memory table?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -