随笔档案「2013年12月」 - 中國風

12 2013 档案

SQL2012(聚合函数+排序函数)用法介绍

摘要：/*************************************** 2012 - Aggregate with order ****************************************/ ;with CTEOrders as (select cast(1 as int) as OrderID, cast('3/1/2012' as date) as OrderD... 阅读全文

posted @ 2013-12-31 23:54 中國風阅读(304) 评论(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 CustomerName union select 2, '3/1/2012', 11.00, 'Sam' u... 阅读全文

posted @ 2013-12-31 23:40 中國風阅读(253) 评论(0) 推荐(0)