Re: [SQL] order of rows in update

2008-09-03 Thread Achilleas Mantzios
Στις Wednesday 03 September 2008 15:28:04 ο/η Richard Broersma έγραψε: > On Tue, Sep 2, 2008 at 11:56 PM, Achilleas Mantzios > <[EMAIL PROTECTED]> wrote: > > I am using my version of DB mirror to do some kind of "Conditional row > > grained + FK dependency oriented lazy replication". > > (The logi

Re: [SQL] order of rows in update

2008-09-03 Thread Richard Broersma
On Tue, Sep 2, 2008 at 11:56 PM, Achilleas Mantzios <[EMAIL PROTECTED]> wrote: > I am using my version of DB mirror to do some kind of "Conditional row > grained + FK dependency oriented lazy replication". > (The logic behind it is the cost of comms, because the slaves are servers in > vessels in

Re: [SQL] order of rows in update

2008-09-02 Thread Achilleas Mantzios
Στις Tuesday 02 September 2008 17:24:05 ο/η Richard Broersma έγραψε: > On Tue, Sep 2, 2008 at 2:58 AM, Achilleas Mantzios > <[EMAIL PROTECTED]> wrote: > > is there an (implicit) way to make a multirow update execute on some rows > > prior to other rows? > > It is needed in a case where a trigger i

Re: [SQL] order of rows in update

2008-09-02 Thread Richard Broersma
On Tue, Sep 2, 2008 at 2:58 AM, Achilleas Mantzios <[EMAIL PROTECTED]> wrote: > is there an (implicit) way to make a multirow update execute on some rows > prior to other rows? > It is needed in a case where a trigger is defined on the table as FOR EACH > ROW, and it is mandatory > that the trigg