Posted by Erland Sommarskog on 05/19/06 00:58

Dani (danielsanberger@googlemail.com) writes:
> i am completely new to SQL Server. So how can I do that? With
> Integration Services?

INSERT db1.dbo.tbl (col1, col2, col3, ....)
SELCET col1, col2, col3, ....
FROM db2.dbo.tbl
WHERE ....

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: sp_fkeys stored procedue is very slow
• Prev in forum: Re: ADO.NET Timeout Exception - I have tried everything
• Thread view: Re: Copy a table from one DB to antoher in SQL Server 2005

[Reply to this message]