Bulk Update

• GregCrossan

  SSC Rookie

  Points: 28

  More actions

  July 15, 2003 at 2:45 pm

  #81200

  I have a few tables that have invalid data. We have been give 3 files which have been created with the proper values.

  keyNum|Value1|Value2

  What is the best way to update the corresponding existing recors with the updated data?

  Note: Very Important not to fire the triggers!!!

• Rajesh Patavardhan

  SSCrazy

  Points: 2801

  More actions

  July 16, 2003 at 2:32 am

  #465636

  Triggers can be disabled using following script

  ALTER TABLE <tablename> DISABLE TRIGGER <triggername>

  Remember to enable the trigger once update is completed.

  Regarding your other query regarding updating invalid data, please put some more details on exact scenario.