Методическое пособие 506
.pdf/* Equipment R/49 Work_Log ON PARENT DELETE SET NULL */
update Work_Log set
/* Work_Log.NumberEquipment = NULL */ Work_Log.NumberEquipment = NULL
from Work_Log,deleted where
/* Work_Log.NumberEquipment = deleted.NumberEquipment */
Work_Log.NumberEquipment = deleted.NumberEquipment
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Equipment R/48 Schedule_of_TI ON PARENT DELETE SET NULL */
update Schedule_of_TI set
/* Schedule_of_TI.NumberEquipment = NULL */ Schedule_of_TI.NumberEquipment = NULL
from Schedule_of_TI,deleted where
/* Schedule_of_TI.NumberEquipment = deleted.NumberEquipment */
Schedule_of_TI.NumberEquipment = deleted.NumberEquipment
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Equipment R/45 Documents ON PARENT DELETE SET NULL */
update Documents set
/* Documents.NumberEquipment = NULL */ Documents.NumberEquipment = NULL
from Documents,deleted where
/* Documents.NumberEquipment = deleted.NumberEquipment */
110
Documents.NumberEquipment = deleted.NumberEquipment
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Equipment R/39 Compliance ON PARENT DELETE SET NULL */
update Compliance set
/* Compliance.NumberEquipment = NULL */ Compliance.NumberEquipment = NULL
from Compliance,deleted where
/* Compliance.NumberEquipment = deleted.NumberEquipment */
Compliance.NumberEquipment = deleted.NumberEquipment
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */ return
error:
raiserror @errno @errmsg rollback transaction
end go
create trigger tI_Equipment on Equipment for INSERT as /* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* INSERT trigger on Equipment */ 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 */
/* Shop R/47 Equipment ON CHILD INSERT SET NULL */ 111
if
/* update(NumberShop) */ update(NumberShop)
begin
update Equipment set
/* Equipment.NumberShop = NULL */ Equipment.NumberShop = NULL
from Equipment,inserted where
/* */ and
not exists (
select * from Shop where
/* inserted.NumberShop = Shop.NumberShop */ inserted.NumberShop = Shop.NumberShop
)
end
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */ return
error:
raiserror @errno @errmsg rollback transaction
end go
create trigger tU_Equipment on Equipment for UPDATE as /* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* UPDATE trigger on Equipment */ begin
declare @numrows int, @nullcnt int, @validcnt int,
@insNumberEquipment int, 112
@errno int,
@errmsg varchar(255)
select @numrows = @@rowcount
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Equipment R/52 Counters ON PARENT UPDATE SET NULL */
if
/* update(NumberEquipment) */ update(NumberEquipment)
begin
update Counters set
/* Counters.NumberEquipment = NULL */ Counters.NumberEquipment = NULL
from Counters,deleted where
/* Counters.NumberEquipment = deleted.NumberEquipment
*/
Counters.NumberEquipment = deleted.NumberEquipment
end
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Equipment R/49 Work_Log ON PARENT UPDATE SET NULL */
if
/* update(NumberEquipment) */ update(NumberEquipment)
begin
update Work_Log set
/* Work_Log.NumberEquipment = NULL */ Work_Log.NumberEquipment = NULL
from Work_Log,deleted where
/* Work_Log.NumberEquipment = deleted.NumberEquipment */
113
Work_Log.NumberEquipment = deleted.NumberEquipment
end
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Equipment R/48 Schedule_of_TI ON PARENT UPDATE 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,deleted where
/* Schedule_of_TI.NumberEquipment = deleted.NumberEquipment */
Schedule_of_TI.NumberEquipment = deleted.NumberEquipment
end
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Equipment R/45 Documents ON PARENT UPDATE SET NULL */
if
/* update(NumberEquipment) */ update(NumberEquipment)
begin
update Documents set
/* Documents.NumberEquipment = NULL */ Documents.NumberEquipment = NULL
from Documents,deleted where
/* Documents.NumberEquipment = deleted.NumberEquipment */
114
Documents.NumberEquipment = deleted.NumberEquipment
end
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Equipment R/39 Compliance ON PARENT UPDATE SET NULL */
if
/* update(NumberEquipment) */ update(NumberEquipment)
begin
update Compliance set
/* Compliance.NumberEquipment = NULL */ Compliance.NumberEquipment = NULL
from Compliance,deleted where
/* Compliance.NumberEquipment = deleted.NumberEquipment */
Compliance.NumberEquipment = deleted.NumberEquipment
end
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Shop R/47 Equipment ON CHILD UPDATE SET NULL */ if
/* update(NumberShop) */ update(NumberShop)
begin
update Equipment set
/* Equipment.NumberShop = NULL */ Equipment.NumberShop = NULL
from Equipment,inserted where
/* */ and
not exists (
select * from Shop
115
where
/* inserted.NumberShop = Shop.NumberShop */ inserted.NumberShop = Shop.NumberShop
)
end
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */ return
error:
raiserror @errno @errmsg rollback transaction
end go
create trigger tD_Materials on Materials for DELETE as /* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* DELETE trigger on Materials */ begin
declare @errno int, @errmsg varchar(255)
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Materials R/50 Work_Log ON PARENT DELETE SET NULL */
update Work_Log set
/* Work_Log.Number_materials = NULL */ Work_Log.Number_materials = NULL
from Work_Log,deleted where
/* Work_Log.Number_materials = deleted.Number_materials
*/
Work_Log.Number_materials = deleted.Number_materials
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */ return
116
error:
raiserror @errno @errmsg rollback transaction
end go
create trigger tU_Materials on Materials for UPDATE as /* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* UPDATE trigger on Materials */ begin
declare @numrows int, @nullcnt int, @validcnt int,
@insNumber_materials int, @errno int,
@errmsg varchar(255)
select @numrows = @@rowcount
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Materials R/50 Work_Log ON PARENT UPDATE SET NULL */
if
/* update(Number_materials) */ update(Number_materials)
begin
update Work_Log set
/* Work_Log.Number_materials = NULL */ Work_Log.Number_materials = NULL
from Work_Log,deleted where
/* Work_Log.Number_materials = deleted.Number_materials
*/
Work_Log.Number_materials = deleted.Number_materials
end
117
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */ return
error:
raiserror @errno @errmsg rollback transaction
end go
create trigger tD_Organization on Organization for DELETE as /* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* DELETE trigger on Organization */ begin
declare @errno int, @errmsg varchar(255)
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Organization R/20 Documents ON PARENT DELETE SET NULL */
update Documents set
/* Documents.NumberOfOrganization = NULL */ Documents.NumberOfOrganization = NULL
from Documents,deleted where
/* Documents.NumberOfOrganization = deleted.NumberOfOrganization */
Documents.NumberOfOrganization = deleted.NumberOfOrganization
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Organization R/5 Employees ON PARENT DELETE SET NULL */
update Employees set
/* Employees.NumberOfOrganization = NULL */ Employees.NumberOfOrganization = NULL
from Employees,deleted where
118
/* Employees.NumberOfOrganization = deleted.NumberOfOrganization */
Employees.NumberOfOrganization = deleted.NumberOfOrganization
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */ return
error:
raiserror @errno @errmsg rollback transaction
end go
create trigger tU_Organization on Organization for UPDATE as /* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* UPDATE trigger on Organization */ begin
declare @numrows int, @nullcnt int, @validcnt int,
@insNumberOfOrganization int, @errno int,
@errmsg varchar(255)
select @numrows = @@rowcount
/* ERwin Builtin Sat Apr 20 22:19:41 2019 */
/* Organization R/20 Documents ON PARENT UPDATE SET NULL */
if
/* update(NumberOfOrganization) */ update(NumberOfOrganization)
begin
update Documents set
/* Documents.NumberOfOrganization = NULL */ Documents.NumberOfOrganization = NULL
119