Home Forums SQL Server 2008 T-SQL (SS2K8) Geography datatype problem in updation RE: Geography datatype problem in updation

  • August 14, 2012 at 2:37 am

    #1525392

    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