把今年所有的周六周日都插入一张表里

declare @datetime datetime,@weekday char(6)
set @datetime='2017-1-1'
while @datetime<='2017-12-31'
begin
select @weekday=datename(weekday,@datetime)
if @weekday='星期六' insert bas_Holiday([HolidayTime]) values(@datetime)
if @weekday='星期日' insert bas_Holiday([HolidayTime]) values(@datetime)
select @datetime=dateadd(day,1,@datetime)
end
go

select * from bas_Holiday;