yuqicook

摘要： 1.清空日志 DUMP TRANSACTION 库名 WITH NO_LOG 2.企业管理器--右键你要压缩的数据库--所有任务--收缩数据库--收缩文件. 阅读全文

摘要： 一天 "select * from T_news where datediff(day,addtime,getdate())=0"; 三天 "select * from T_news where datediff(day,addtime,getdate())= 0"; 一周 "SELECT * FROM T_news WHERE (DATEPART(wk, addtime) = DATEPART(wk, GETDATE())) AND (DATEPART(yy, addtime) = DATEPART(yy, GETDATE()))"; 一月"SELECT * FROM T_news WHERE (DATEPART(yy, addtime) = DATEPART(yy, GETDATE())) AND (DATEPART(mm, addtime) = DATEPART(mm, GETDATE()))"; 一季度 "select * from T_news where DATEPART(qq, 阅读全文