如何使用sql server中的虚拟列筛选查询？

Question

我希望根据select语句中的虚拟列在查询中设置where条件。

select *,
       dbo.DictanceKM(cast(u.latitude as float),
       @lat,
       cast(u.longitude as float),@long) as distance 
from Table u
where distance < 10

有可能吗？

Answer 1

您可以直接指定它：

select *,dbo.DictanceKM(cast(u.latitude as float),
                        @lat,cast(u.longitude as float),@long) as distance 
from Table u
where dbo.DictanceKM(cast(u.latitude as float),
                     @lat,cast(u.longitude as float),@long)<10

或者使用子查询：

SELECT *
FROM (select *,dbo.DictanceKM(cast(u.latitude as float),
                              @lat,cast(u.longitude as float),@long) as distance 
      from Table u) sub
WHERE distance < 10