Results 1 to 4 of 4

Thread: Bulk copy data

  1. #1
    Join Date
    Sep 2004
    Posts
    4

    Question Unanswered: Bulk copy data

    Dear All,

    Can anyone tell me what's the best/easiest way to copy one column of data from one table to another column of another table.

    Thanks in advance.

  2. #2
    Join Date
    Jan 2004
    Location
    Shanghai,China
    Posts
    76
    Do the tow tables have relationships?
    If they have ralationships,so u can do by update statement.
    eg,
    update table1 set col2=table2.col2
    FROM table2 WHERE table1.col1=table2.col1
    Last edited by enhydraboy; 12-06-04 at 21:35.

  3. #3
    Join Date
    Sep 2004
    Posts
    4
    What if they don't have relationships?


    Quote Originally Posted by enhydraboy
    Do the tow tables have relationships?
    If they have ralationships,so u can do by update statement.
    eg,
    update table1 set col2=table2.col2
    FROM table2 WHERE table1.col1=table2.col1

  4. #4
    Join Date
    Sep 2004
    Location
    Helsinki, Finland
    Posts
    45
    Could you explain a little more what you are trying to do...
    ...it doesn't sound like a good idea to insert data into a table that has no relations to the data that already exsists!?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •