CODEWITHSUNDEEP
sqlsql-servergeospatial
Craig
Craig

Reputation: 36816

SQL Server 2008 Geospatial queries

SQL Server 2008 has new geo data types. One thing I am wondering though is that if I have a table with geocoded addresses in it, can I write a query to display all records within a certain distance. For example, many websites have the option to search for items within a certain distance such as 50 miles and would like it if SQL 2008 provided this out of the box.

Upvotes: 3

Views: 2071

Answers (1)

ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells

Reputation: 66612

This is exactly the sort of query a spatial index is designed to support. This blog entry gives a quick introduction that includes this type of query.

Upvotes: 4

Related Questions