Copy Table to Another Database

Posted by Derek Dieter on SQL Server Planet See other posts from SQL Server Planet or by Derek Dieter
Published on Thu, 27 May 2010 17:44:41 +0000 Indexed on 2010/05/27 17:53 UTC
Read the original article Hit count: 209

Filed under:
There are few methods of copying a table to another database, depending on your situation. Same SQL Server Instance If trying to copy a table to a database that is on the same instance of SQL Server, The easiest solution is to use a SELECT INTO while using the fully qualifed database names.SELECT * INTO Database2.dbo.TargetTable FROM Database1.dbo.SourceTableThis will [...]

© SQL Server Planet or respective owner

Related posts about DBA