SQL Server空间数据库之STBuffer

查询一条线某个距离的缓冲区范围内的所有管。。

DECLARE @g3 geometry
SET @g3 = geometry::STGeomFromText('LINESTRING(x1 y1,x2 y2)',4326);
select * from LightWeightPipe.dbo.xxxx_xxx_xx_xxx_EVW a where @g3.STBuffer(0.000001).STIntersects(a.Shape)=1

 https://docs.microsoft.com/zh-tw/sql/t-sql/spatial-geometry/stbuffer-geometry-data-type?view=sql-server-ver15