title: How use syntax on SQL Server
body: <p>I user of pgadmin... I have a problem with SQL Server syntax for spatial joins.</p>
  
  <p>I need this query on SQL Server:</p>
  
  <pre><code>select * 
  from table a, table b
  where st_within (st_centroid(a.geom), b.geom)
  </code></pre>
  
  <p>or </p>
  
  <pre><code>update table a 
  set x = b.x
  from table b
  where st_within (st_centroid(a.geom), b.geom)
  </code></pre>