SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Daily SQL Server 2008 New Feature – Day 12

Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply for awareness. You can then go away and research the area and report back to me, we’ll then discuss how these new features can benefit us all.

Friday 21st May 2010

Spatial Data Types

SQL Server 2008 now allows you to build spatial capabilities into your applications.

In brief, there are two new data types.

Geography – allows you to implement Round Earth solutions using latitude and longitude coordinates to define areas on the Earth’s surface.

Geometry – allows you to implement Flat Earth solutions. We can now store polygons, points, and lines that are associated with projected planar surfaces and naturally planar data, such as interior spaces. 


No comments.

Leave a Comment

Please register or log in to leave a comment.