in reply to Best way to check which field(s) was changed

Cue reference to Little Bobby Tables. Use placeholders!. Also don't worry too much about "what changed", unless one of the fields is a LOB. Prepare one update statement that updates the whole row. But use placeholders, or suffer the wrath of Little Bobby Tables.
  • Comment on Re: Best way to check which field(s) was changed