摘要:
很有用的sql语句。MicrosoftInternetExplorer402DocumentNotSpecified7.8Normal01.--查询当天:select*from[TABLE]whereDateDiff(dd,[dateadd],getdate())=02.--查询24小时内的:select*from[TABLE]whereDateDiff(hh,[dateadd],getDate())<=243.--本月记录SELECT*FROM[TABLE]WHEREdatediff(month,[dateadd],getdate())=04.--本周记录SELECT*FROM[TAB 阅读全文