By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,265 Members | 1,333 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,265 IT Pros & Developers. It's quick & easy.

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

P: n/a
Hi all,

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

Thanks for your help
Daniel

May 18 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Dani (da*************@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
May 18 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.