学步园

create table SatSun2([id] int identity(1,1),[date] datetime,[weekday] char(6))<br /> go<br /> declare @datetime datetime,@weekday char(6)<br /> set @datetime='2010-1-1'<br /> while @datetime<='2010-12-31'<br /> begin<br /> select @weekday=datename(weekday,@datetime)<br /> if @weekday NOT IN ( 'Saturd' ,'Sunday') insert SatSun2([date],[weekday]) values(@datetime,@weekday)<br /> select @datetime=dateadd(day,1,@datetime)<br /> end<br /> go<br /> select * from satsun2<br /> drop table satsun<br />  

--在英文版的SQL2008内测试通过