只用触发器:create trigger trigA on table1
for update
as
begin declare @oldid int,@newid int
select @oldid=物料id from deleted
select @newid=物料id from inserted update table2 set [成品/半成品id]=@newid where [成品/半成品id]=@oldid
update table2 set 配件id=@newid where 配件id=@oldidendcreate trigger trigB on table2
for insert,update
as
begin declare @newid int
if update([成品/半成品id])
begen
select @newid=[成品/半成品id] from inserted
if not exists (select * from table1 where 物料id=@newid
raiserror(...)
end if update(配件id])
begen
select @newid=配件id from inserted
if not exists (select * from table1 where 物料id=@newid
raiserror(...)
endend
for update
as
begin declare @oldid int,@newid int
select @oldid=物料id from deleted
select @newid=物料id from inserted update table2 set [成品/半成品id]=@newid where [成品/半成品id]=@oldid
update table2 set 配件id=@newid where 配件id=@oldidendcreate trigger trigB on table2
for insert,update
as
begin declare @newid int
if update([成品/半成品id])
begen
select @newid=[成品/半成品id] from inserted
if not exists (select * from table1 where 物料id=@newid
raiserror(...)
end if update(配件id])
begen
select @newid=配件id from inserted
if not exists (select * from table1 where 物料id=@newid
raiserror(...)
endend
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货