摘要：select count(ArticleID), datename(year, AddTime) as year, datename(month, AddTime) as monthfrom Blog_Article where UserID=163 and Status=2 group by datename(year, AddTime) , datename(month, AddTime) 阅读全文