Thinking outside the box

Patron Saint of Lost Yaks
posts - 203, comments - 734, trackbacks - 4

My Links

Advertisement

News

Archives

Post Categories

First test with November CTP

declare

@sample table (p geography)

insert @sample
select geography::STGeomFromText('POINT(12.65100 65.34900)', 4619) union all
select
geography::STGeomFromText('POINT(35.65100 23.34900)', 4619) union all
select
geography::STGeomFromText('POINT(64.65100 12.34900)', 4619)

DECLARE @h geography

SET @h = geography::STGeomFromText('POINT(47.65100 -122.34900)', 4619)

SELECT p.STDistance(@h) / 1000 as [km]
from @sample

Print | posted on Thursday, November 22, 2007 11:38 PM | Filed Under [ SQL Server 2008 ]

Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET