Results 1 to 6 of 6

Thread: Mass update of records (SQL Svr 2k) [RESOLVED]

Threaded View

  1. Apr 10th, 2005, 06:47 AM #1
    tailz
    tailz is offline

    Thread Starter
    Hyperactive Member tailz's Avatar
    Join Date
    Jul 2002
    Posts
    306

    Resolved Mass update of records (SQL Svr 2k) [RESOLVED]

    Hi all,

    In one hand I have a table with approx 200,000 records in and a field that needs populating.

    In the other hand I have a text file containing 200,000 identifying fields and the value that should be in the field delimited by a tab.

    Whats the fastest way to do the update?

    I have bad hangover and everything blurry so hope that makes sense :]

    Cheers
    Last edited by tailz; Apr 10th, 2005 at 08:01 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width