declare @dt1 datetime
declare @dt2 datetime
set @dt1='2002-11-1'
set @dt2='2002-11-30'declare @tmp table (dt datetime)
declare @dt datetime
set @dt=@dt1
while @dt<=@dt2
begin
if datepart(weekday,@dt)<>'1' and datepart(weekday,@dt)<>'7'
insert @tmp values(@dt)
set @dt=dateadd(day,1,@dt)
endselect * from @tmp
declare @dt2 datetime
set @dt1='2002-11-1'
set @dt2='2002-11-30'declare @tmp table (dt datetime)
declare @dt datetime
set @dt=@dt1
while @dt<=@dt2
begin
if datepart(weekday,@dt)<>'1' and datepart(weekday,@dt)<>'7'
insert @tmp values(@dt)
set @dt=dateadd(day,1,@dt)
endselect * from @tmp
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货