|
-
Apr 10th, 2005, 07:07 AM
#2
Fanatic Member
Re: Mass update of records (SQL Svr 2k)
If they are all new rows, use the Import wizard in Enterprise Manager to import straight into the table.
If they are existing rows that just need updating you can import them via above method into a temp table then do a sql update from query analyser.
Could probably help a bit more if I knew what was in the text file and the data structure of the table you are trying to put them into.
Blade
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
|