Wednesday, March 13, 2013

Changing the Geom value to text

declare @geom geometry
set @geom = Geometry::STGeomFromText('MULTIPOINT ((' + CAST(@lon AS varchar(20)) + ' ' + CAST(@lat AS varchar(20)) + '))',4326)

No comments:

Post a Comment