SQL Server 2008: Using the Geometry Data Type to Work with 3 and 4 Dimensions

  • Article

I just recently got finished doing a few MSDN gigs and was asked by Lee W. if you can use the new SQL Server 2008 Geometry data type to store 3D info.  I honestly didn't know so poked around the Books Online (BOL) and, sure enough, you can do it.  Here is a friggin great post on just general use of the new data types and, in the section entitled "Displaying WKT in 2, 3, & 4 Dimensions", you will find some great info on "doing" the dimensions muhahahah

 

https://blogs.msdn.com/davidlean/archive/2008/11/01/sql-2008-spatial-samples-part-2-of-n-background-on-spatial-types-well-known-text-wkt.aspx