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 Instance Types

IN SQL Server 2008, the GEOMETRY and GEOGRAPHY data types supported seven spatial type classes that you can create and work with in a database:

Image POINTA POINT is an exact location and is defined in terms of an X and Y pair of coordinates, as well as optionally by Z (elevation) and M (measure) coordinates. It does not have a length or any area associated with it. These instance types are used as the fundamental building blocks of more complex spatial types.

Image MULTIPOINTA MULTIPOINT is a collection of zero or more points.

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