I need top update several tables with new values from an external text file. That would notrmally be a no brainer, (even for me) :) But, what is important this time around, is I can NOT fire the triggers, or every user would get notified of a 150,000 updates.
The text file contains 4 fields
KEYNUM|UpdateField1|UpdateField2|Class
Class will be either 1 or 2, if class = 1 then table 1 contains the record, if class = 2 then table 2 contains the record...
Any help, as always is greatly appreciatedHi,
By default BCP does not fire triggers, it will only fire triggers if you use the FIRE_TRIGGERS hint.
Does that change anything or help?|||Originally posted by bmalar
Hi,
By default BCP does not fire triggers, it will only fire triggers if you use the FIRE_TRIGGERS hint.
Does that change anything or help?
That Part I knew (but thanks). How can I use bcp to update selected records? (i.e. update records based on values in the KEYNUM field)|||Originally posted by GregCrossan
That Part I knew (but thanks). How can I use bcp to update selected records? (i.e. update records based on values in the KEYNUM field)
Sorry I didn't read your post correctly.. I thought you were inserting new records.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment