Re: Update Question

It's like that cat in the box problem. However when you have 100 million rows to deal with your going to hear all those tree's fall and the ground is probably going to move a bit. So if I can selectively choose which tree's life maybe a little better.

Nick

nice try.

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:<J2Rp9.13473$uF6.25294_at_rwcrnsc52.ops.asp.att.net>...
> If a tree falls in the woods and no one is around to hear it does it make a
> sound?
>
> Does it matter? How would you know since nothing changed? I bet it does.
> Jim
> "Niko" <nick_wakefield_at_hotmail.com> wrote in message
> news:9da94cd1.0210111725.229035be_at_posting.google.com...
> > Hi,
> >
> > Does anyone know that what the database does if you do an update and
> > the value you are setting is the same as what you are setting it to.
> >
> > e.g
> >
> > SALES
> > ID, VALUE
> > 1 1000
> > 2 2000
> >
> >
> > update SALES set VALUE = 1000 where ID = 1;
> >
> > Does it not do the update or will it actually do the update eventhough
> > the data is the same.
> >
> > TIA
Received on Tue Oct 15 2002 - 18:37:00 CDT