我以前会用trigger,但现在我倾向于存储过程"有则取出原来的加上现在要插入的数据"应该是update b set b.field=b.field+a.field from a,b where b.id=a.id我猜的,估计是这个意思吧
不就是用两句SQL解决吗? UPDATE A SET COL1 = COL1 + (SELECT COL1 FROM B WHERE A.ID=B.ID) WHERE EXISTS (SELECT 'X' FROM B WHERE A.ID=B.ID) /INSERT INTO A SELECT * FROM B WHERE NOT EXISTS (SELECT 'X' FROM A WHERE A.ID=B.ID);用SQL SERVER的语法改一下就行了
UPDATE A
SET COL1 = COL1 + (SELECT COL1 FROM B WHERE A.ID=B.ID)
WHERE EXISTS (SELECT 'X' FROM B WHERE A.ID=B.ID)
/INSERT INTO A
SELECT * FROM B
WHERE NOT EXISTS (SELECT 'X' FROM A WHERE A.ID=B.ID);用SQL SERVER的语法改一下就行了