[thelist] SQL Update

[Jason Robbins]

Hey

I have a webpage (aspx) that updates a SQL DB (MS SQL 2000) and I was 
wondering. At the moment when I code an update I update everything the 
user could have possibly changed, one simple update command, done. I 
have been wondering though in the interests of good coding and such 
should I only be updating the fields that have actually changed? I 
realise that this would involve coding for all options (which could be a 
big numbet) or is there a simpler way?

Your thoughts please

Jas