Методическое пособие 506
.pdffrom Documents,deleted where
/* Documents.NumberOfOrganization = deleted.NumberOfOrganization */
Documents.NumberOfOrganization = deleted.NumberOfOrganization
end
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Organization R/5 Employees ON PARENT UPDATE SET NULL */
if
/* update(NumberOfOrganization) */ update(NumberOfOrganization)
begin
update Employees set
/* Employees.NumberOfOrganization = NULL */ Employees.NumberOfOrganization = NULL
from Employees,deleted where
/* Employees.NumberOfOrganization = deleted.NumberOfOrganization */
Employees.NumberOfOrganization = deleted.NumberOfOrganization
end
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */ return
error:
raiserror @errno @errmsg rollback transaction
end go
120
create trigger tD_Schedule_of_TI on Schedule_of_TI for DELETE as
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */ /* DELETE trigger on Schedule_of_TI */ begin
declare @errno int, @errmsg varchar(255)
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Schedule_of_TI R/44 Documents ON PARENT DELETE SET NULL */
update Documents set
/* Documents.Number_of_TO = NULL */ Documents.Number_of_TO = NULL
from Documents,deleted where
/* Documents.Number_of_TO = deleted.Number_of_TO */ Documents.Number_of_TO = deleted.Number_of_TO
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */ return
error:
raiserror @errno @errmsg rollback transaction
end go
create trigger tI_Schedule_of_TI on Schedule_of_TI for INSERT as
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */ /* INSERT trigger on Schedule_of_TI */ begin
declare @numrows int, @nullcnt int, @validcnt int, @errno int,
121
@errmsg varchar(255)
select @numrows = @@rowcount
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Equipment R/48 Schedule_of_TI ON CHILD INSERT SET NULL */
if
/* update(NumberEquipment) */ update(NumberEquipment)
begin
update Schedule_of_TI set
/* Schedule_of_TI.NumberEquipment = NULL */ Schedule_of_TI.NumberEquipment = NULL
from Schedule_of_TI,inserted where
/* */ and
not exists (
select * from Equipment where
/* inserted.NumberEquipment = Equipment.NumberEquipment */
inserted.NumberEquipment = Equipment.NumberEquipment
)
end
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */ return
error:
raiserror @errno @errmsg rollback transaction
end go
122
create trigger tU_Schedule_of_TI on Schedule_of_TI for UPDATE as
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */ /* UPDATE trigger on Schedule_of_TI */ begin
declare @numrows int, @nullcnt int, @validcnt int,
@insNumber_of_TO int, @errno int,
@errmsg varchar(255)
select @numrows = @@rowcount
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Schedule_of_TI R/44 Documents ON PARENT UPDATE SET NULL */
if
/* update(Number_of_TO) */ update(Number_of_TO)
begin
update Documents set
/* Documents.Number_of_TO = NULL */ Documents.Number_of_TO = NULL
from Documents,deleted where
/* Documents.Number_of_TO = deleted.Number_of_TO */ Documents.Number_of_TO = deleted.Number_of_TO
end
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Equipment R/48 Schedule_of_TI ON CHILD UPDATE SET NULL */
if
/* update(NumberEquipment) */ update(NumberEquipment)
begin
123
update Schedule_of_TI set
/* Schedule_of_TI.NumberEquipment = NULL */ Schedule_of_TI.NumberEquipment = NULL
from Schedule_of_TI,inserted where
/* */ and
not exists (
select * from Equipment where
/* inserted.NumberEquipment = Equipment.NumberEquipment */
inserted.NumberEquipment = Equipment.NumberEquipment
)
end
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */ return
error:
raiserror @errno @errmsg rollback transaction
end go
create trigger tD_Shop on Shop for DELETE as /* ERwin Builtin Sat Apr 20 22:19:41 2019 */ /* DELETE trigger on Shop */
begin
declare @errno int, @errmsg varchar(255)
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Shop R/47 Equipment ON PARENT DELETE SET NULL */ update Equipment
set
124
/* Equipment.NumberShop = NULL */ Equipment.NumberShop = NULL
from Equipment,deleted where
/* Equipment.NumberShop = deleted.NumberShop */ Equipment.NumberShop = deleted.NumberShop
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Shop R/43 Documents ON PARENT DELETE SET NULL */ update Documents
set
/* Documents.NumberShop = NULL */ Documents.NumberShop = NULL
from Documents,deleted where
/* Documents.NumberShop = deleted.NumberShop */ Documents.NumberShop = deleted.NumberShop
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Shop R/38 Compliance ON PARENT DELETE SET NULL
*/
update Compliance set
/* Compliance.NumberShop = NULL */ Compliance.NumberShop = NULL
from Compliance,deleted where
/* Compliance.NumberShop = deleted.NumberShop */ Compliance.NumberShop = deleted.NumberShop
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */ return
error:
raiserror @errno @errmsg rollback transaction
end
125
go
create trigger tU_Shop on Shop for UPDATE as /* ERwin Builtin Sat Apr 20 22:19:41 2019 */ /* UPDATE trigger on Shop */
begin
declare @numrows int, @nullcnt int, @validcnt int, @insNumberShop int, @errno int,
@errmsg varchar(255)
select @numrows = @@rowcount
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Shop R/47 Equipment ON PARENT UPDATE SET NULL */ if
/* update(NumberShop) */ update(NumberShop)
begin
update Equipment set
/* Equipment.NumberShop = NULL */ Equipment.NumberShop = NULL
from Equipment,deleted where
/* Equipment.NumberShop = deleted.NumberShop */ Equipment.NumberShop = deleted.NumberShop
end
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Shop R/43 Documents ON PARENT UPDATE SET NULL */ if
/* update(NumberShop) */ update(NumberShop)
begin
update Documents
126
set
/* Documents.NumberShop = NULL */ Documents.NumberShop = NULL
from Documents,deleted where
/* Documents.NumberShop = deleted.NumberShop */ Documents.NumberShop = deleted.NumberShop
end
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Shop R/38 Compliance ON PARENT UPDATE SET NULL */ if
/* update(NumberShop) */ update(NumberShop)
begin
update Compliance set
/* Compliance.NumberShop = NULL */ Compliance.NumberShop = NULL
from Compliance,deleted where
/* Compliance.NumberShop = deleted.NumberShop */ Compliance.NumberShop = deleted.NumberShop
end
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */ return
error:
raiserror @errno @errmsg rollback transaction
end go
create trigger tI_Work_Log on Work_Log for INSERT as /* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* INSERT trigger on Work_Log */ 127
begin
declare @numrows int, @nullcnt int, @validcnt int, @errno int,
@errmsg varchar(255)
select @numrows = @@rowcount
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Employees R/51 Work_Log ON CHILD INSERT SET NULL */
if
/* update(nomerOfEmployees) */ update(nomerOfEmployees)
begin
update Work_Log set
/* Work_Log.nomerOfEmployees = NULL */ Work_Log.nomerOfEmployees = NULL
from Work_Log,inserted where
/* */ and
not exists (
select * from Employees where
/* inserted.nomerOfEmployees = Employees.nomerOfEmployees */
inserted.nomerOfEmployees = Employees.nomerOfEmployees
)
end
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Materials R/50 Work_Log ON CHILD INSERT SET NULL */ if
/* update(Number_materials) */ 128
update(Number_materials) begin
update Work_Log set
/* Work_Log.Number_materials = NULL */ Work_Log.Number_materials = NULL
from Work_Log,inserted where
/* */ and
not exists (
select * from Materials where
/* inserted.Number_materials = Materials.Number_materials */
inserted.Number_materials = Materials.Number_materials
)
end
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Equipment R/49 Work_Log ON CHILD INSERT SET NULL */
if
/* update(NumberEquipment) */ update(NumberEquipment)
begin
update Work_Log set
/* Work_Log.NumberEquipment = NULL */ Work_Log.NumberEquipment = NULL
from Work_Log,inserted where
/* */ and
not exists (
select * from Equipment where
129