我有一个名为get_distance(point1,point2)的函数,用于计算两点之间的距离。我想要计算表(geometry)列(points)顶行中的点与已经定义的变量(point_variable)之间的距离。我正在运行以下查询,但无法终止:
-- Assume point_variable has already been defined as a varchar and
-- has a value
-- Assume that there is a column (points) in my table
-- (geometry) with only points stored as varchar
-- Also, assume that there is a scalar function (get_distance) that
-- takes as input two points (as 2 varchar parameters)and computes
-- and returns the distance as an int
SELECT get_distance(point_variable, (SELECT TOP 1 points from
geometry))我正在运行前面的代码,查询永远不会终止。我的目标是获得points列顶行中的条目和变量point_variable之间的距离。我应该如何尝试解决此问题?
发布于 2019-06-23 09:41:11
尝试将查询结果声明为一个变量,然后将其传递给函数:
DECLARE @POINTS_VAR VARCHAR(MAX)
SET @POINTS_VAR = (SELECT TOP 1 points from geometry)
SELECT get_distance(point_variable, @POINTS_VAR)https://stackoverflow.com/questions/56720399
复制相似问题