DECLARE @g geography;
SET @g = geography::STPointFromText(‘POINT(113.216273 23.236333)‘, 4326);
SELECT @g.ToString();
DECLARE @gg geography;
SET @gg = geography::STPointFromText(‘POINT(115.567368 37.341209)‘, 4326);
SELECT @gg.ToString();
SELECT @g.STDistance(@gg)
原文：http://www.cnblogs.com/libinbin/p/3866266.html