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