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
 General SQL Server Forums
 New to SQL Server Programming
 SELECT * INTO TABLE

Author  Topic 

stahorse
Yak Posting Veteran

86 Posts

Posted - 2014-02-07 : 06:02:23
Hi

how can I archive to SELECT * INTO existing table without listing column names?

Abu-Dina
Posting Yak Master

206 Posts

Posted - 2014-02-07 : 06:30:15
You don't! You use INSERT INTO instead as the target table already exists!
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2014-02-10 : 08:53:14
same as
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=191181

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -