Geo Fencing Code - A clean implementation of SQL Server 2008

Question

I need help. I am looking for the full TSQL code. (no C ++ / C #)

• define 32 points around a central point forming a quasicircle with a given radius in miles.

• Check the 32 points above for a given point to see if it is included in the geo-face.

Thanks JJ

Answer 1

You should study the spatial types of SQL Server 2008, in particular geometry . To accomplish what you ask, you must do the following:

• Create a point using STGeomFromText .
• Buffer your point using STBuffer () to create a circle.
• Use STIntersects () to determine if other points are in your circle.