Re: Hierarchy as 'UP' constraint

Foreign key on pnr + instead of trigger in SQL Server

CREATE TRIGGER treenodes_delete
ON treenodes
instead of delete
AS
DECLARE @RowCount INT
repet:

    update treenodes
    set pnr=(select pnr from deleted where deleted.nr=treenodes.pnr)     where exists (select * from deleted where deleted.nr=treenodes.pnr);

    SELECT @RowCount = @@ROWCOUNT ;

if @RowCount>0

    goto repet ;

delete treenodes
from treenodes t, deleted d
where t.nr=d.nr;

This needs some changes to cope with various root encodings. How this would perform on large tables ? Received on Fri Nov 25 2005 - 05:29:44 CST