Re: Hierarchy as 'UP' constraint
From: x <x_at_not-exists.org>
Date: Fri, 25 Nov 2005 13:29:44 +0200
Message-ID: <dm6sjd$bad$1_at_domitilla.aioe.org>
Date: Fri, 25 Nov 2005 13:29:44 +0200
Message-ID: <dm6sjd$bad$1_at_domitilla.aioe.org>
Foreign key on pnr + instead of trigger in SQL Server
CREATE TRIGGER treenodes_delete
update treenodes
SELECT _at_RowCount = @@ROWCOUNT ;
if _at_RowCount>0
goto repet ;
ON treenodes
instead of delete
AS
DECLARE _at_RowCount INT
repet:
set pnr=(select pnr from deleted where deleted.nr=treenodes.pnr)
where exists (select * from deleted where deleted.nr=treenodes.pnr);
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 - 12:29:44 CET