Latitude and Longitude with the Geography Data Type - SQL Training Online

The Geography data type is used in many different SQL Server databases. It contains Latitude, Longitude, and many other properties and functions.

In this video I show you how to extract the latitude and longitude from the Geography data type.

I use the Wide World Importers and the following scripts:

--SQL Geography Data Type

select CityName

,Location.Lat Latitude

,Location.Long Longitude

,cast(location as varchar(max))

from Application.Cities

Link to the a good tutorial on MSSQLTips.com.

See the original Latitude and Longitude in SQL Server video.