Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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. 

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.