34,576
社区成员
发帖
与我相关
我的任务
分享
update a
set a.fid=1,a.bid=b.bid
from myTable a,
(select bid from myTable where fid=1) b
where a.name='王五'
update myTable set fid=1,bid=(select top 1 bid from myTable where fid=1) from myTable where name='王五'