SqlServer中geometry是一种存储空间数据的格式,其数据主要有点线面等几种格式:
POINT(100 50) //点
LINESTRING (100 100, 20 180, 180 180) //线
POLYGON ((0 0, 150 0, 150 150, 0 150, 0 0)) //面
INSERT INTO sde.dbo.TEST(OBJECTID,phone,name,shape) VALUES (130,'13','ceshi',geometry::STGeomFromText('POINT(133.4 38.5)', 4326));
UPDATE sde.dbo.TEST SET SHAPE =geometry::STGeomFromText('POINT(133.4 38.5)', 4326) WHERE OBJECTID=130
delete sde.dbo.TEST WHERE OBJECTID=130
网友评论