阅读背景:

试图限制SQL Server命令中的结果

来源:互联网 
<asp:SqlDataSource ID="dsSearchResults" runat="server" 
                ConnectionString="<%$ ConnectionStrings:strConn %>" 
    <SelectCommand="SELECT StoreNumber, StoreName, Address, City, State, PostalCode, Phone, Email, Latitude, Longitude, SQRT(POWER(Latitude - @Latitude, 2) + POWER(Longitude - @Longitude, 2)) * 62.1371192 AS DistanceFromAddress 
                    FROM Stores 
                    WHERE (ABS(Latitude - @Latitude) &lt; 1.75) AND (ABS(Longitude - @Longitude) &lt; 1.75) 
                    ORDER BY DistanceFromAddress">
   <SelectParameters>
<asp:SqlDataSource ID="dsSearchResults" runat="



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: