触发器执行后，主动触发的表怎么没有更新？

[lmpeel]

比如：
CREATE TRIGGER insertToWL ON [dbo].[invoice]
FOR INSERT
AS

Declare @cvouchid nvarchar(30)
Declare @coperator nvarchar(20)
Declare @ccuscode nvarchar(20)

select @cvouchid = cvouchid , @coperator = coperator , @cCusCode = cCusCode from invoice inserted

insert into d_order(orderid,adate,cid,startworker)
values(@cVouchID,convert(varchar,getDate(),20),@cCusCode,@cOperator)

上面的触发器，在往invoice表插入数据时，在d_order表中会自动添加，但是在invoice表中确没有数据，应该怎么写才能2个表都插入数据? 也就是说怎么写才不影响原表的数据更新？

[wzy_love_sly]

CREATE TRIGGER insertToWL 
ON [dbo].[invoice]
FOR INSERT
AS
begin
insert into d_order(orderid,adate,cid,startworker)
select cvouchid,convert(varchar,getDate(),120),cCusCode,coperator from inserted
end

[中国风]

CREATE TRIGGER insertToWL ON [dbo].[invoice]
FOR INSERT
AS

insert into d_order(orderid,adate,cid,startworker)
select cvouchid , convert(varchar,getDate(),20),cCusCode,coperator
from  inserted

[fcuandy]

CREATE TRIGGER insertToWL ON invoice
FOR INSERT
AS
BEGIN
	INSERT d_order (orderID,aDate,cID,startWorker)
	SELECT cvouchid,coperator,convert(varchar,getDate(),20),cCusCode,cOperator FROM INSERTED
END

[lmpeel]

谢了，
是不是select @cvouchid = cvouchid , @coperator = coperator , @cCusCode = cCusCode from invoice inserted 语句的功能就是把inserted表中的数据取走了，inserted便不会插入数据了？ 那么如果我要把字段值取出来做运算后再插入呢？该怎么写？