DECLARE @id int select @id=id from inserted insert into b (id) values (@id)
CREATE TRIGGER FROUM_USER_INSERT ON A FOR INSERT AS INSERT INTO B(filds1,filds2,filds3,filds4) SELECT filds1,filds2,filds3,filds4 FROM INSERTED 上面是一个简单的例子,Inserted中保存的就是当前插入A中的记录!
@id int
select @id=id from inserted
insert into b (id) values (@id)
FOR INSERT
AS
INSERT INTO B(filds1,filds2,filds3,filds4)
SELECT filds1,filds2,filds3,filds4 FROM INSERTED
上面是一个简单的例子,Inserted中保存的就是当前插入A中的记录!