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

[SQL] order of rows in update

2008-09-02 Thread Achilleas Mantzios
Hi, 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 trigger is run for some certain rows before it is run on the rest of the rows. Is there