CREATE TRIGGER property_insret
on Property
for insert
as
begin
insert A select Fld_UserName,Fld_PropertyName,Fld_Time,Fld_PropertyNumber,Fld_Propertyprice from inserted
end
触发完后,他把Property表的所以数据都插入到了A表里,我只想把刚添加的新数据触发到A表里
请问高手怎么解决
on Property
for insert
as
begin
insert A select Fld_UserName,Fld_PropertyName,Fld_Time,Fld_PropertyNumber,Fld_Propertyprice from inserted
end
触发完后,他把Property表的所以数据都插入到了A表里,我只想把刚添加的新数据触发到A表里
请问高手怎么解决
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货