June 22nd, 2012, 02:07 AM
How to copy SQL 2005 Express Data Table fastest?
In SQL Server 2005 Express, assuming there are 2 database: ABC and XYZ, I want to copy some of the ABC into the database table XYZ. Right click in the table do not see why ABC copy, do it manually create the database tables and import XYZ too long, in SQL Server 2005 does not support copy of the database table to the database?
June 22nd, 2012, 02:40 AM
Depending on what you need to copy you could possibly use a select...into query.
SELECT fieldA, fieldB, fieldC
Recycle your old CD's, don't just trash them
If I helped you out, show some love with some reputation, or tip with Bitcoins to 1N645HfYf63UbcvxajLKiSKpYHAq2Zxud
October 21st, 2013, 12:28 AM
Your SQL statement is not. for example i want to copy table TabUsername the Northwind database into databases QLKD, how ?, you see attachments file http://www.crocko.com/DD5D9C792D224FBDAF7F78E130E478FE/CopyTable.jpg