7.22.2010

MS-SQL UPDATE...SELECT 做大量更新

update a set a2=b.b2, a3=b.b3, ...
from b
where a.a1=b.b1