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 |
|
AsimKhaliq
Yak Posting Veteran
94 Posts |
 Posted - 2004-07-13 : 12:28:53
|
| HiguysIam forgetting the syntex of insert statement for temp table in which we dont have to create temp tablesome thing like this !!!!!!!!!!!1Insert into #abd (select Abc, xyz from tablename)tHNX |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-07-13 : 12:32:40
|
| Select abc, xyz Into #abd From tablenameCorey |
 |
|
|
AsimKhaliq
Yak Posting Veteran
94 Posts |
Posted - 2004-07-13 : 12:35:28
|
| THNX WORKS FINE FOR ME |
|
|
|
|
|
|
insert into temptable without creating table