Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I tried to execute this query on my SQL Server 2008 R2 instance:

UPDATE ITEMS
SET GEOG=geography::STPointFromText('POINT(0 90)', 4326);

SQL Server returned the following error:

System.FormatException: 24201: Latitude values must be between -90 and 90 degrees

I also tried POINT(0 89.99) and got the same error.

How do I set a point to be the North Pole?

share|improve this question
    
SELECT geography::STPointFromText('POINT(0 90)', 4326) doesn't raise any errors for me. –  Martin Smith Dec 23 '11 at 15:01

2 Answers 2

Try this instead, with (or without) decimal points

DECLARE @a geography
SET @a=geography::STPointFromText('POINT(0.0 90.0)', 4326)

if this works - then something wrong with the ITEMS table

share|improve this answer
up vote 0 down vote accepted

Solved. the problem was raised by a trigger enabled on the table. the problem is that the trigger contain exactly the same code to update the GEOG field when GEO_LAT and LON field are updated... really strange but for now the problem is solved also without 0.0 and 90.0

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.