Post reply

Update Query

  • February 11, 2010 at 9:52 pm

    #220563

    Hi

    i want to update a table from another server and also i want to insert the missing records from that table...

    both the table has same structure...

    pls help

    its urgent

  • February 12, 2010 at 12:07 am

    #1117889

    Use a merge statement.

    To get data from the remote server you can use either SSIS or a linked server.

    Regards,

    Willem
    http://wschampheleer.wordpress.com[/url]

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

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