csdn_cSharp的博客

declare @datetime datetime,@weekday char(6) set @datetime='2017-1-1' while @datetime begin select @weekday=datename(weekday,@datetime) if @weekday='星期六' insert bas_Holiday([HolidayTime]) values(@