update [Tree_Monitoring_Philips].[dbo].[T_NumberOfTrees] SET [TreeLatitude]=’18°38’33.8352″‘,[TreeLongitude]=N’73°48’9.85″E’ WHERE [ID]=1
How to update the latitude longitude in SQL server The latitude and longitude are in degree per minutes seconds and SQL server is enclosing the update query for minutes as per their defined update query format and does not get work the query.
New contributor
Harshal Patil is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.