02 2012 档案

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 阅读(400) 评论(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 阅读(1124) 评论(0) 推荐(0)
ie6下li标签之间有空隙
摘要：在li下加float：left； 阅读全文
posted @ 2012-02-03 12:51 connlyn 阅读(138) 评论(0) 推荐(0)
ie6下margin间距是两倍的解决办法
摘要：在ul和li中加上一个display:inline;对于容器，另一个解决方法就是把后面的这个容器也设为float 阅读全文
posted @ 2012-02-03 12:50 connlyn 阅读(174) 评论(0) 推荐(0)