Stewart "Arturius" Campbell (8/14/2012)
Have you tried:
UPDATE [dbo].[LocationCopy]
SET
LocationGeography = geography::Point(@Latitude, @Longitude, 4326)
WHERE LocationID = @ID
Thanks it worked
When i googled everyone using this method STGeomFromText
LocationGeography = geography::STGeomFromText('POINT(@Latitude @Longitude)', 4326)
What is the problem with this statement