Copy a table from one DB to antoher in SQL Server 2005
This is a discussion on Copy a table from one DB to antoher in SQL Server 2005 within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi all, i am completely new to SQL Server. So how can I do that? With Integration Services? Thanks ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 08:25 PM
| ||||
| ||||
 Re: Copy a table from one DB to antoher in SQL Server 2005 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/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx      |
Linear Mode
