How Update one table row with combare with the other polygon table using their geom i

[المشرف العام]

a-> pointsb -> Polygon

i want to update city trow in table a with compare b of geom in SQL server

this is the PostgreSQL Query

update a set city=b.name from b where st_contains(b.the_geom, a.the_geom)

how convert this to sql server or how update city trow in table a, on SQL server



أكثر...