deadlocks between single update statements ?

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 ?

How do you prevent this ?

Thanks much. Received on Sat Sep 23 2006 - 03:41:02 CDT