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?
Craig Johnston, Jul 14, 2011
PLease try to create a user-defined type for your own need
Tarriq Ferrose Khan, Aug 26, 2011