12 2013 档案

SQL2012(聚合函数+排序函数)用法介绍
摘要：/***************************************2012 - Aggregate with order****************************************/;with CTEOrders as (select cast(1 as int)... 阅读全文
posted @ 2013-12-31 23:54 正牌风哥 阅读(247) 评论(0) 推荐(0)
SQL2008避免出错（聚合函数+Over用法）
摘要：--返回出错with CTEOrders as (select cast(1 as int) as OrderID, cast('3/1/2012' as date) as OrderDate, cast(10.00 as money) as OrderAmt, 'Joe' as Customer... 阅读全文
posted @ 2013-12-31 23:40 正牌风哥 阅读(231) 评论(0) 推荐(0)