Copy a table from one DB to antoher in SQL Server 2005

Hi all,

i am completely new to SQL Server. So how can I do that? With
Integration Services?

Thanks for your help
DanielDani (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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx