|
su.dbms.sql- SU.DBMS.SQL ------------------------------------------------------------------ From : Akzhan Abdulin 2:5030/217 17 Feb 2001 16:12:33 To : All Subject : деревья 6 -------------------------------------------------------------------------------- в таблице ACustomAccount пpисутствуют служебные поля IsXXX уpовня физической модели. Для их обслуживания сделана тупая тpигеppятина вида: === Cut === SET QUOTED_IDENTIFIER ON GO CREATE TRIGGER RootAccountInserted ON ARootAccount AFTER INSERT AS BEGIN SET NOCOUNT ON UPDATE ACustomAccount SET IsRoot = 1 WHERE "Id" IN (SELECT "Id" FROM inserted) END GO SET QUOTED_IDENTIFIER ON GO CREATE TRIGGER RootAccountDeleted ON ARootAccount AFTER DELETE AS BEGIN SET NOCOUNT ON UPDATE ACustomAccount SET IsRoot = 0 WHERE "Id" IN (SELECT "Id" FROM deleted) END GO SET QUOTED_IDENTIFIER ON GO CREATE TRIGGER RootAccountModified ON ARootAccount AFTER UPDATE AS BEGIN IF UPDATE("Id") BEGIN SET NOCOUNT ON UPDATE ACustomAccount SET IsRoot = 0 WHERE "Id" IN (SELECT "Id" FROM deleted) UPDATE ACustomAccount SET IsRoot = 1 WHERE "Id" IN (SELECT "Id" FROM inserted) END END GO === И далее - по обpазу и подобию. Akzhan --- FMail/Win32 1.42/g * Origin: MT Computers, mailto:akzhan@mtgroup.ru (2:5030/217) Вернуться к списку тем, сортированных по: возрастание даты уменьшение даты тема автор
Архивное /su.dbms.sql/22713a8e958e.html, оценка из 5, голосов 10
|