Tuesday 16 April 2019

Add a geography column for fetching lat long using geojson in sql server


DECLARE @g geography;
SET @g = geography::STGeomFromText('POINT(16.0557 75.9547)', 4326);
SELECT cast(@g.ToString() as geography)



Result------------

0xE6100000010C705F07CE19FD52402063EE5A420E3040

No comments:

Post a Comment

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...