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)
 
 

Вернуться к списку тем, сортированных по: возрастание даты  уменьшение даты  тема  автор