CREATE TRIGGER tr_tb_insert
ON tb
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;
UPDATE TB SET A=T2.A,B=T2.B,C=T2.C
FROM TB T1
JOIN TBTEST T2 ON T1.ID=T2.ID
WHERE T1.ID IN (SELECT ID FROM inserted);
END
GO
ON tb
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;
UPDATE TB SET A=T2.A,B=T2.B,C=T2.C
FROM TB T1
JOIN TBTEST T2 ON T1.ID=T2.ID
WHERE T1.ID IN (SELECT ID FROM inserted);
END
GO
像2楼写的:SELECT ID FROM inserted
on tb
instead of insert
as begin
insert into tb(id,a,b,c)
select a.id,a.a,a.b,a.c
from tabtest a
join inserted b on a.id=b.id
end