sqlsever坐标转换为空间数据

 

select geometry::STGeomFromText('POINT('+ CAST(CAST(c_abs_x  AS DECIMAL(36, 12)) AS VARCHAR(50)) +' '+CAST(CAST(c_abs_y  AS DECIMAL(36, 12)) AS VARCHAR(50))+')', 2435) c_geom,* from [dbo].[t_grid_point] where c_status=0