update [sde].Ageo_VillageRiver set Village =
r.OBJECTID from [sde].Ageo_Village r
where r.shape.STContains([sde].Ageo_VillageRiver.shape)=1
--这种方法通用
update [sde].Ageo_VillageRiver set Village =
r.OBJECTID from [sde].Ageo_Village r
where r.shape.STContains(Ageo_VillageRiver.shape.STEnvelope().STCentroid())=1
r.OBJECTID from [sde].Ageo_Village r
where r.shape.STContains([sde].Ageo_VillageRiver.shape)=1
--这种方法通用
update [sde].Ageo_VillageRiver set Village =
r.OBJECTID from [sde].Ageo_Village r
where r.shape.STContains(Ageo_VillageRiver.shape.STEnvelope().STCentroid())=1