用触发器实现吧。 create trigger t_insert on 表A for insert as begin
insert 表B select * from inserted i
end
这是以前roy_888写的. create trigger inserttableB on tableA after insert insert into tableB select * from inserted go create trigger updatetableB on tableA after update delete from tableB where id in (select id from deleted) inert into tableB select * from inserted go create trigger deletetableB on tableA after delete delete from tableB where id in (select id from deleted) go --需要注意的是,tableB表的id不能为自增列.
create trigger inserttable_表a on 表a after insert insert into 表b (编码,名称,状态) select 编码,名称,状态 from inserted---------------------- 以上语法,错在哪里呢?
on A
for insert
as
begin
insert into B select *from inserted;
end
create trigger t_insert on 表A
for insert
as
begin
insert 表B select * from inserted i
end
这是以前roy_888写的.
create trigger inserttableB
on tableA
after insert
insert into tableB select * from inserted
go
create trigger updatetableB
on tableA
after update
delete from tableB where id in (select id from deleted)
inert into tableB select * from inserted
go
create trigger deletetableB
on tableA
after delete
delete from tableB where id in (select id from deleted)
go
--需要注意的是,tableB表的id不能为自增列.
on 表a
after insert
insert into 表b
(编码,名称,状态)
select 编码,名称,状态
from inserted----------------------
以上语法,错在哪里呢?