create table SatSun2([id] int identity(1,1),[date] datetime,[weekday] char(6)) go declare @datetime datetime,@weekday char(6) set @datetime='2010-1-1' while @datetime<='2010-12-31' begin select @weekday=datename(weekday,@datetime) if @weekday NOT IN ( 'Saturd' ,'Sunday') insert SatSun2([date],[weekday]) values(@datetime,@weekday) select @datetime=dateadd(day,1,@datetime) end go select * from satsun2 drop table satsun --在英文版的SQL2008内测试通过