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.
| Author |
Topic |
|
sunitagoswami
Starting Member
10 Posts |
 Posted - 2006-12-12 : 08:36:32
|
| When I am trying to execute this statement in the "Northwind" database in SQL SERVER 2000Create table #temp as(select * from Orders)I am getting error as Incorrect syntax near the keyword 'as'.Please advice...Sunita |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-12 : 08:38:28
|
| This is a MS SQL Server forum!select *into #tempfrom ordersIf you have other DBMS, please post in www.dbforums.comPeter LarssonHelsingborg, Sweden |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-12 : 11:44:27
|
| 1 The target table wont have the indices, constraint, etc2 Locking issue should be considered if there are millions of table3 Better to precreate table and then insert data to itMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Create TAble