有两个表oen和two,都拥有id字段,要求two表中的字段反映one表中的数据变化。
创建update触发器create trigger trig_update
on one
for update
as
if update(id)
beginupdate two
set two.id=inserted.id
from two,inserted,deleted
where two.id=deleted.idend创建delete触发器
create trigger trig_delete
on one
for delete
as
delete two
from two,deleted
where two.id=deleted.id创建insert触发器 CREATE TRIGGER trig_insert
ON one
FOR INSERT
AS
begin
insert into two(two.Id)
select (inserted.Id)
from inserted
end
创建update触发器create trigger trig_update
on one
for update
as
if update(id)
beginupdate two
set two.id=inserted.id
from two,inserted,deleted
where two.id=deleted.idend创建delete触发器
create trigger trig_delete
on one
for delete
as
delete two
from two,deleted
where two.id=deleted.id创建insert触发器 CREATE TRIGGER trig_insert
ON one
FOR INSERT
AS
begin
insert into two(two.Id)
select (inserted.Id)
from inserted
end
on 表1 for insert
as
insert 表2 values ('数据') from inserted
FOR INSERT, UPDATE, DELETE
AS
UPDATE 表2 SET tag=1
正解。现请问如何动态建立触发器?(在客户端程序中使用SQL建立)
此题一旦解决即给分