Post reply

Update one table with another table in a different database

  • October 2, 2009 at 6:23 pm

    #205292

    I have 2 identical tables in 2 different databases. I would like to update one with the other.

    If truncating and inserting is easier. That would work too. I am not sure how to do either one. The id for each row has to remain the same.

    This is what I have so far:

    UPDATE [database1].[dbo].[Faculty]

    SET [LongBio] =

    (SELECT LongBio

    FROM database2.dbo.faculty

    WHERE database2.dbo.faculty.FcultyID = database1.dbo.faculty.FcultyID)

    //LongBio has text datatype

    Thank you!

    Norbert

  • October 2, 2009 at 7:52 pm

    #1061282

    Sorry. Nevermind. I misspelled a field name.

  • October 9, 2009 at 4:13 am

    #1063961

    try this

    http://tek-tips.com/viewthread.cfm?qid=932379

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply