--查询分析器中(两个表中的ID是自增(标识)字段吧?)
use Northwind
go--创建新增同步的触发器
create trigger tr_insert on table1
for insert
as
set identity_insert pubs..table2 on
insert table2(id,姓名,性别)
select id,姓名,性别 from inserted
go--创建删除同步的触发器
create trigger tr_delete on table1
for delete
as
delete a
from table2 a where exists(select 1 from deleted where id=a.id)
go--创建更新同步的触发器
create trigger tr_update on table1
for update
as
update a set 姓名=i.姓名,性别=i.性别
from table2 a join inserted i on a.id=i.id
go
use Northwind
go--创建新增同步的触发器
create trigger tr_insert on table1
for insert
as
set identity_insert pubs..table2 on
insert table2(id,姓名,性别)
select id,姓名,性别 from inserted
go--创建删除同步的触发器
create trigger tr_delete on table1
for delete
as
delete a
from table2 a where exists(select 1 from deleted where id=a.id)
go--创建更新同步的触发器
create trigger tr_update on table1
for update
as
update a set 姓名=i.姓名,性别=i.性别
from table2 a join inserted i on a.id=i.id
go
use Northwind
go--创建新增同步的触发器
create trigger tr_insert on table1
for insert
as
set identity_insert pubs..table2 on
insert pubs..table2(id,姓名,性别)
select id,姓名,性别 from inserted
go--创建删除同步的触发器
create trigger tr_delete on table1
for delete
as
delete a
from pubs..table2 a where exists(select 1 from deleted where id=a.id)
go--创建更新同步的触发器
create trigger tr_update on table1
for update
as
update a set 姓名=i.姓名,性别=i.性别
from pubs..table2 a join inserted i on a.id=i.id
go