update B
set aid=a.ID
from A
where a.Name=b.Name and a.Url=b.Url

------解决方案--------------------
update B set B.aid=A.id from A where B.name=A.name and B.url =A.url