How do I set a geography point to be the North Pole? 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?
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