O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

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 Types

SQL Server 2008 introduces two new data types for working with spatial data—one for each of the two spatial models (as you might have guessed). The geometry data type is provided to store and process spatial data using the planar (flat-earth) model, while its counterpart geography supports the geodetic (round-earth) model.

One nice thing about the new spatial types is that they both use many of the same methods for common spatial calculations. So if you’re working with the geodetic model, you’ll be using longitude and latitude coordinates with the geography data type. For the planar model, you’ll be using x- and y-coordinates with the geometry data type. But in either case, you’ll use many of the same methods for dealing with ...

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