insert into AAA select GETDATE(),name from BBB where aid=0
update a set a = b.a,b=b.b,c=b.c from t a,t b where (a.条件1) and (b.条件2)
insert into AAA select GETDATE(),name from BBB where aid=0
update a set a = b.a,b=b.b,c=b.c from t a,t b where (a.条件1) and (b.条件2)