Geometry

select *, pt.STWithin (poly), pt2.STWithin (poly), line.STIntersects(poly)

 from

 (

  select geometry::STGeomFromText('POLYGON ((0 0, 100 0, 100 100, 0 100, 0 0))', 0) as  poly,

         geometry::STGeomFromText('POINT (50 50)',0) as pt,

geometry::STGeomFromText('POINT (150 150)',0) as pt2,

geometry::STGeomFromText('LINESTRING (200 200, 500 500)', 0) as  line

 )sub