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 2005 Forums
 Express Edition and Compact Edition (2005)
 Copying data from one table to another

Author  Topic 

red2003xlt
Starting Member

4 Posts

Posted - 2008-08-06 : 16:20:30
Hello,

I'm new to SQL Server but a veteran of MS Access

I have two tables Process_SubProcess and Process_SubProcess_Extension

The tables are indentical save for an extra 5 columns on the Process_SubProcess_Extension.

How do I transfer, move, copy, or append data from one table to another?

Apparently the append queries I use in Ms Access are illegal in SQL Server.

Any help?

BTW:I'm using SQL Server Express 2005

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-06 : 16:23:04
INSERT INTO Table1 (Column1, ..., ColumnN)
SELECT Column1, ..., ColumnN
FROM Table2
...

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -