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