03 2018 档案

Sql根据经纬度算出距离
摘要：SELECT ISNULL((2 * 6378.137 * ASIN(SQRT(POWER(SIN((117.223372- ISNULL(Latitude,0) )*PI()/360),2)+COS(117.223372*PI()/180)*COS(117.223372*PI()/180)*POW 阅读全文
posted @ 2018-03-21 11:49 _大维维 阅读(1283) 评论(1) 推荐(0)
SQL varchar转float实现数字比较
摘要：select * from table where cast('经纬度' as float ) < 90 阅读全文
posted @ 2018-03-17 11:05 _大维维 阅读(1536) 评论(0) 推荐(0)