视图触发器问题???
我建立了一个远程数据库表的视图,我如何写这个视图的触发器
使得当远程数据库改变的时候,执行相应视图的触发器
如下例子:
create TRIGGER SAL_AccountInfo_v1_iud ON [dbo].我的视图
instead of insert ,delete ,update
AS
select Account_code,Account_name into #i from inserted
select Account_code,Account_name into #d from deleted
exec('delete from 目标表 where exists(select * from #d where Account_code=目标表.cCusCode)')
exec('insert into 目标表 (cCusCode,cCusName) select * from #i')
go
上面例子,只是改变视图时,才能改变目标表
但是我想,当改变源表的时候,就改变目标表
如何解决!!!!!!!