sql server 2008以上版本支持geometry数据类型
SELECT * FROM [QX_FZJZ].[dbo].MDPR_BI
where geometry::STGeomFromText('POINT(121,41)', 4326)
.STBuffer(5000 / (2 * 3.1415926 * 6371004) * 360).MakeValid()
.STContains(Geometry) = 1
sql server 2008以上版本支持geometry数据类型
SELECT * FROM [QX_FZJZ].[dbo].MDPR_BI
where geometry::STGeomFromText('POINT(121,41)', 4326)
.STBuffer(5000 / (2 * 3.1415926 * 6371004) * 360).MakeValid()
.STContains(Geometry) = 1