摘要：
SET DATEFIRST 1declare @strTime nvarchar(50);set @strTime='week8'; --8月declare @CurYear int;select @CurYear=datepart(year,GETDATE());declare @dateFirstDayOfYear datetime; --年的第一天declare @dateFirstDayOfWeek datetime;--周的第一天declare @dateLastDayOfWeek datetime;--周的最后一天declare @whichtime nvarcha 阅读全文