select count(ArticleID), datename(year, AddTime) as year, datename(month, AddTime) as month
from Blog_Article where UserID=163 and Status=2
group by datename(year, AddTime) , datename(month, AddTime)
posted on 2006-09-03 23:44  星火燎原  阅读(330)  评论(0编辑  收藏  举报