到目前为止,这是我的问题,并对此表示不满: order by c.Location.STDistance(l.location) 多部分标识符"l.location“无法绑定。selectfrom (select top 1 c.UnicodeName, c.name, r.code as region
, s.price-(s.price/100*l.rebate) AS worebate,((s.price-(s.price/100*l.rebate))/100)*s.tax AS valtax,
s.price-(s.price/100*l.rebate)+(((s.price-(s.price/100*l.rebate))