1.
update 表1 set 字段=b.字段
from 表1 a,表2 b where a.id=b.id2.
update 表 set 字段=(select sum(字段) from 表 where id<=10)
where id=11
update 表1 set 字段=b.字段
from 表1 a,表2 b where a.id=b.id2.
update 表 set 字段=(select sum(字段) from 表 where id<=10)
where id=11
update a set id2=b.id2 from a inner join b on a.id=b.id2.a(a1,a2,......a11)update a set a11=a1+a2....+a10
update 表 set 字段11=(字段1+字段2+...+字段10)
update 表1 set 字段=b.字段
from 表1 a,表2 b where a.id=b.id
2.没弄懂,呵呵~~~
update set col11=(col1+col2+...+col10) from yourtable