#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2010
    Posts
    103
    Rep Power
    4

    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?
  2. #2
  3. Wiser? Not exactly.
    Devshed God 1st Plane (5500 - 5999 posts)

    Join Date
    May 2001
    Location
    Bonita Springs, FL
    Posts
    5,944
    Rep Power
    4033
    Depending on what you need to copy you could possibly use a select...into query.

    Code:
    SELECT fieldA, fieldB, fieldC 
    INTO XYZ.dbo.tbl
    FROM ABC.dbo.tbl
    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
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2010
    Posts
    103
    Rep Power
    4
    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

IMN logo majestic logo threadwatch logo seochat tools logo