O'Reilly logo

Programming Microsoft® SQL Server® 2012 by Leonard Lobel and Andrew Brust

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

Integrating with Microsoft Bing Maps

We’ll end this chapter with one final (and fun) geospatial application, in which you will construct a Microsoft Bing Maps mash-up. The term “mash-up” is used to describe a unified presentation combining one set of data with another. For this mash-up, you will create a web application that layers customer coordinates over Bing Maps imagery to show the location of customers in the database as pushpin icons on a map.

Start with a new database. Create the Customer table with a geography column to hold customer locations and populate it with some sample data, as shown in Example 9-31.

Example 9-31. Creating the Customer table and populating it with geographical data.

USE master GO IF EXISTS(SELECT name FROM sys.databases ...

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