O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required