摘要： set datefirst 1select DATEDIFF(wk,'2011-10-30 ','2011-11-1'),DATEPART(ww, '2011-10-30'),DATEPART(ww, '2011-11-1')返回0,44,45　set datefirst 7select DATEDIFF(wk,'2011-10-30 ','2011-11-1'),DATEPART(ww, '2011-10-30'),DATEPART(ww, '2011-11-1') 阅读全文