Thinking outside the box

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

My Links

Advertisement

News

Archives

Post Categories

November 2007 Blog Posts

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

posted @ Thursday, November 22, 2007 11:38 PM | Feedback (0) | Filed Under [ SQL Server 2008 ]

Powered by:
Powered By Subtext Powered By ASP.NET