Microsoft® SQL Server 2012 Unleashed

Spatial Data Support in SSMS

When querying spatial data in SSMS, you’ll find that SSMS has a built-in capability to plot and display some basic maps of your spatial data.

To demonstrate this, you can run the following query in the AdventureWorks2012 database in SSMS:

Click here to view code image

select SpatialLocation    from person.Address a        inner join    person.StateProvince sp        on a.StateProvinceID = sp.StateProvinceID        and sp.CountryRegionCode = 'US'

After the query runs, you should see a Spatial Results tab next to the Results tab (see Figure 44.1). Click this tab, and the location points are plotted on a map. Select the Bonne Projection. If you look closely, you can see that the geographic points plotted roughly provide ...