title: STContains on Geography column
body: <p>I have a bus point in Lat/long (geography). I want to check where my bus point (lat/long) lies in a region. My region is a set of lat/long points. I have lat/long of a region (Outline of the lat/longs which makes a region) in geography form. Now I have one point lat/long and I want to identify if that point lies inside my region. How can I do that? 4000 points make an outline of a region and one point is to check if that exist in that region or not. How will I check that? </p>
  
  <p>I think I can use <code>STContains</code> or <code>STintersect</code> but I don't know the exact syntax.</p>
  
  <pre><code>SELECT
      Region.BlockID, Bus_Route.geography
  FROM
      Bus_Route, Region
  WHERE
      Region.points.STContains(Bus_Route.geography) = 1
  </code></pre>