Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
declare @Year int
set @Year=2009
select
m as [Date],
sum(
case when datepart(month,AccessDateTime)=m
then AccessCount else 0 end
) as [Count]
from
Counter c,
(
select 1
5/14 首页 上一页 3 4 5 6 7 8 下一页 尾页
