Re: deadlocks between single update statements ?

Jonathan Lewis wrote :

> <hasta_l3_at_hotmail.com> wrote in message
> news:1159000862.384129.73710_at_i3g2000cwc.googlegroups.com...
> > Dear group,
> >
> > Assume a transaction A with a single update statement updating many
> > rows of a table.
> > Assume another transaction B also with a single update, concurrently
> > updating the same rows, but perhaps in a different order.
> >
> > Can these single updates deadlock ?
> >
> If the row updates are in exactly the same
> order, the second transaction will wait for
> the first transaction to commit or rollback.
>
> If the row updates are in a different order
> you will get a deadlock.
>

Thanks, Jonathan.

I would prefer to have the two statements update the row in the same order.
But how do I impose an order in an update statement ? Received on Sat Sep 23 2006 - 04:35:03 CDT