How to update the latitude and longitude in SQL Server
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 […]
How to update the lattitude and longitude in SQL Server
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. sql sql-server sql-update latitude-longitude New […]
How to update the lattitude and longitude in ms-sql
update [Tree_Monitoring_Philips].[dbo].[T_NumberOfTrees] SET [TreeLatitude]=’18°38’33.8352″‘,[TreeLongitude]=N’73°48’9.85″E’ WHERE [ID]=1