--在TempEccFeature表中增加一列Flag,外部追加时Flag为1即可。create trigger TempTriggerEcc on TempEccFeature for insert as begin if exists (select * from inserted where flag=1) insert into EccFeature(Place,Spare,Speed,Datetime,Aecc,Gap,Pecc,Falg) select Place,Spare,Speed,Datetime,Aecc,Gap,Pecc,0 --此处用0 from Inserted end
--在TempEccFeature表中增加一列Flag,外部追加时Flag为1即可。create trigger TempTriggerEcc on TempEccFeature for insert as
begin
if exists (select * from inserted where flag=1)
insert into EccFeature(Place,Spare,Speed,Datetime,Aecc,Gap,Pecc,Falg)
select Place,Spare,Speed,Datetime,Aecc,Gap,Pecc,0 --此处用0
from Inserted
end