关于触发器的

[dingpiao]

有A,B,C三张表

A 中有 id_1,c_1 ， B 中有 id_1 ,id_2 ，C中有 id_2 ,c_2

其中，A的id_1与B的id_1对应，B的id2与C的id_2对应

想做个触发器，A中插入c_1时也插入到C中的c_2

以前没写过，那位能给个模板啊

[victorycyz]

模板，查询分析器中不是有吗？

IF EXISTS (SELECT name
FROM sysobjects
WHERE name = N'<trigger_name, sysname, trig_test>'
AND type = 'TR')
DROP TRIGGER <trigger_name, sysname, trig_test>
GO

CREATE TRIGGER <trigger_name, sysname, trig_test>
ON <table_name, sysname, pubs.dbo.sales>
FOR INSERT
AS
BEGIN
RAISERROR (50009, 16, 10)
END
GO

[zjcxc]

create trigger t_insert on a
for insert
insert into c(c_2) select c_1 from inserted
go

[yoki]

CREATE TRIGGER tr_ins
ON C
FOR INSERT
AS
BEGIN
insert into C (c_2)
select c_1 from inserted
END
GO

[dingpiao]

id 得对应啊

[zjcxc]

--id 得对应啊,用:
create trigger t_insert on a
for insert
insert into select * from inserted
go

[dingpiao]

抱歉啊，我说错了，应该是更新而不是插入

[zjcxc]

--id 得对应啊,用:

create trigger t_insert on a
for insert
insert into c select * from inserted
go

[zjcxc]

--更新:
create trigger t_insert on a
for update
if update(c_1)
update c set c_2=a.c_1
from b join c on b.id2=c.id_2
join inserted a on a.id_1=b.id_1
go

[dingpiao]

我试试，如果成的话，马上给分