2012年2月6日
ms sqlserver查询各个月份的记录
摘要： 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 阅读全文
posted @ 2012-02-06 11:30 connlyn 阅读(392) 评论(0) 推荐(0)
ms sqlserver 查询今天，昨天，最近7天，最近一个月的记录
摘要： 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 阅读全文
posted @ 2012-02-06 11:27 connlyn 阅读(1120) 评论(0) 推荐(0)