-- 插入数据到A表
insert into A(BrNo,kmno,AccNo,dbalance,cbalance,Adate)
SELECT BrNo,kmno,AccNo,dbalance,cbalance, Adate
FROM B
where dbalance+cbalance<>0
------------------------------------- Should be
insert into A(BrNo,kmno,AccNo,dbalance,cbalance,Adate)
SELECT BrNo,kmno,AccNo,dbalance,cbalance, Adate
FROM INSERTED
where dbalance+cbalance<>0
insert into A(BrNo,kmno,AccNo,dbalance,cbalance,Adate)
SELECT BrNo,kmno,AccNo,dbalance,cbalance, Adate
FROM B
where dbalance+cbalance<>0
------------------------------------- Should be
insert into A(BrNo,kmno,AccNo,dbalance,cbalance,Adate)
SELECT BrNo,kmno,AccNo,dbalance,cbalance, Adate
FROM INSERTED
where dbalance+cbalance<>0
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货