ms sqlserver查询各个月份的记录

select * from Works where  DATEPART(m,[WUpLoadTime])=1  

select * from Works where  DATEPART(m,[WUpLoadTime])=2

select * from Works where  DATEPART(m,[WUpLoadTime])=3

select * from Works where  DATEPART(m,[WUpLoadTime])=4

select * from Works where  DATEPART(m,[WUpLoadTime])=5

posted @ 2012-02-06 11:30  connlyn  阅读(372)  评论(0)  编辑  收藏  举报