Join Now
|
Login
home
login
join now
products and pricing
design pattern framework
javascript pattern framework
database pattern framework
adaptive data models
design patterns
javascript tutorial
sql + database tutorial
all tutorials
connection strings
visual studio shortcuts
c# coding standards
html color codes
all references
explore
questions
ask question
tags
users
contact us
training courses
schedule
registration
sitemap
about us
training and education for professional developers
login
join now
C#, ASP.NET, WPF, WCF, LINQ, PATTERNS
Home
Questions
Question
« Prev Topic
|
Next Topic »
Appropriate datatype for Latitude and Longitude in SQL Server
Craig Johnston
128
96.5
Jul 14, 2011
0
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?
Thanks,
Graig.
SQL Server
Latitude
Longitude
GeoLocation
Add Comment
Flag
Follow
Email
1 answer
answer date
votes
comments
Tarriq Ferrose Khan
80
96.1
Aug 26, 2011
0
PLease try to create a user-defined type for your own need
Add Comment
Flag
Link
Write Your Answer
return to top