SQL Server插入geography类型数据:
INSERT INTO wht_g(c_geography)
VALUES
(
geography :: STGeomFromText (
'POINT(55.9271035250276 -3.29431266523898)',
4326)
)
SQL Server插入geometry类型数据:
INSERT INTO wht_g(c_geometry)
VALUES
(
geometry :: STGeomFromText (
'POLYGON((-122.358 47.653, -122.348 47.649, -122.348 47.658, -122.358 47.658, -122.358 47.653))',
4326)
)
SQL Server插入c_hierarchyid类型数据:
INSERT INTO wht_g(c_hierarchyid) VALUES ('/1/1/1/');