xxxx18一60岁hd中国/日韩女同互慰一区二区/西西人体扒开双腿无遮挡/日韩欧美黄色一级片 - 色护士精品影院www

  • 大小: 0.82KB
    文件類型: .txt
    金幣: 1
    下載: 0 次
    發布日期: 2021-03-26
  • 語言: 其他
  • 標簽: 存儲過程??

資源簡介

USE [NSA]
GO
/****** Object:  StoredProcedure [dbo].[BufferSelect] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[BufferSelect]
@WKT varchar(2000),
@startPt varchar(30),
@Buffer int,
@OrderbyX int
AS
begin
declare @stPt geometry;
set @stPt=geometry::STGeomFromText(@startPt,4326);
declare @urplace GEOGRAPHY;
set @urplace= GEOGRAPHY::STGeomFromText(@WKT,4326);
declare @bufArea GEOGRAPHY
set @bufArea = @urplace.STBuffer(3);
declare @bufArea2 geometry
set @bufArea2=geometry::STGeomFromWKB(@bufArea.STAsBinary(),4326)
select  p.*,l.LineID as LineName,l.Path as LinePath from SVPoint p left join SVLine l on p.LineID=l.LineID inner join (
select ptID as PointID, PtGeo from SVPointGeo where PtGeo.Filter(@bufArea2)=1 
) g on p.PointID= g.PointID order by g.PtGeo.STDistance(@stPt)

資源截圖

代碼片段和文件信息

評論

共有 條評論