摘要：
select * from Works where DATEPART(m,[WUpLoadTime])=1 select * from Works where DATEPART(m,[WUpLoadTime])=2select * from Works where DATEPART(m,[WUpLoadTime])=3select * from Works where DATEPART(m,[WUpLoadTime])=4select * from Works where DATEPART(m,[WUpLoadTime])=5 阅读全文
摘要：
select * from Works where datediff(d,AddTime,getdate())<0select * from Works where datediff(d,AddTime,getdate())<1select * from Works where datediff(d,AddTime,getdate())<7select * from Works where datediff(d,AddTime,getdate())<30 阅读全文