Pro_monkey的专栏

方法1：计算目标是否在范围内，平均执行7500msDECLARE @GGP_LOCATE_POINT GEOGRAPHY = GEOGRAPHY::Point(31.358772277832,120.690238952637, 4326);  DECLARE @buffer GEOGRAPHY;set @buffer=@GGP_LOCATE_POINT.STBuffer(1000);SELECT ...

exec的结果无法直接赋值给变量，可以先把结果插入到临时表，再select出来  insert into #tmpEndTime exec sp_executesql @sql,N'@a nvarchar(100) output',@a outputselect 字段 from #tmpEndTime...