Home  /  Questions  /  Question

128   96.7
Jul 14, 2011

Appropriate datatype for Latitude and Longitude in SQL Server

I need to store Latitude and Longitude data in SQL Server.  
The data comes from Google in the following format: xxx.xxxxxx.

I was thinking of using DECIMAL(9,6).
Is this accurate enough for subsequent distance and other calculations?


90   96.5
Aug 26, 2011
PLease try to create a user-defined type for your own need