摘要:
SELECT CONVERT(VARCHAR(10), dtCreateTime, 120) AS dtStatisticsCreateDate, COUNT(1) AS nStatisticsCount FROM Web_Statistics WHERE datepart(hh,dtCreateT 阅读全文
摘要:
SELECT CONVERT(VARCHAR(10), DATEADD(dd, number, '2015-10-25'), 120) AS dtDate FROM master..spt_values WHERE type = 'P' AND DATEADD(dd, number, '2015-1 阅读全文