07 2014 档案

sql 计算两经纬度间的距离
摘要：DECLARE @g geography;SET @g = geography::STPointFromText('POINT(113.216273 23.236333)', 4326);SELECT @g.ToString();DECLARE @gg geography;SET @gg = geo... 阅读全文
posted @ 2014-07-24 18:21 不疼不痒,不吵不闹 阅读(259) 评论(0) 推荐(0)
两张表行转列案例
摘要：B表 A表 SELECT PV.* FROM ( SELECT b.DeliverLineType, b.DeliverLineTypeName, conve... 阅读全文
posted @ 2014-07-17 11:48 不疼不痒,不吵不闹 阅读(275) 评论(0) 推荐(0)