40分求助触发器新手问题

[usercainiao]

//首先声明我不会写触发器,下面的问题可能有点白痴,我就40分了,解决了就40分!

CREATE trigger InertAB
on mainab
@id int
@number int
@shopname varchar(100)
@regionalwork varchar(100)
@keepcharge varchar(100)
@succeedcharge varchar(100)
@datatime datetime

@id int
@number int
@workerid varchar(100)
@projectitem varchar(100)
@onestandards varchar(100)
@twostandards varchar(100)
@shreestandards varchar(100)
@fourstandards varchar(100)
@datatime datetime
after (insert into mainab(id,number,shopname,regionalwork,keepcharge,succeedcharge,datatime,test)
values (id,number,shopname,regionalwork,keepcharge,succeedcharge,datatime))
as
(insert into deputyab(id,number,workerid,projectitem,onestandards,twostandards,shreestandards,fourstandards,datatime)
values(id,number,workerid,projectitem,onestandards,twostandards,shreestandards,fourstandards,datatime))

谁帮我改改这个触发器 让我实现插入功能 在线等

[liangCK]

触发器是什么应该知道吧?

[usercainiao]

知道啊,我就想insert into mainab的时候就insert into deputy啊

[liangCK]

create trigger insertab on mainab
for insert
as
insert deputy select * from inserted
go

[usercainiao]

我咋没看懂啊 哥们你能加我QQ不?
我太感激你了

[usercainiao]

我QQ506795

[liangCK]

说实话.
你写的东西.我没看懂.

[pt1314917]

CREATE trigger InertAB on mainab for insert
as 
	insert into deputyab(id,number,workerid,projectitem,onestandards,twostandards,shreestandards,fourstandards,datatim)
select id,number,shopname,regionalwork,keepcharge,succeedcharge,datatime,test from inserted

[pt1314917]

上面字段一一对应即可``

[kelph]

--from inserted
inserted就是mainab表中刚插入的数据