create table zzz(a varchar(10),b datetime)declare @RDate datetime,@EndTime datetime
set @RDate ='2005-12-01'
set @EndTime='2005-12-31'while @RDate<=@EndTime
begin
insert zzz(select ClassNo from ClassInfo)a
select ClassNo,@RDate from ClassInfo
set @RDate=dateadd(dd,1,@RDate)
end
go
set @RDate ='2005-12-01'
set @EndTime='2005-12-31'while @RDate<=@EndTime
begin
insert zzz(select ClassNo from ClassInfo)a
select ClassNo,@RDate from ClassInfo
set @RDate=dateadd(dd,1,@RDate)
end
go
set @RDate ='2005-12-01'
set @EndTime='2005-12-31'while @RDate<=@EndTime
begin
insert zzz select ClassNo,@RDate from ClassInfo
set @RDate=dateadd(dd,1,@RDate)
end
go
create table #t(date_time datetime)
declare @RDate datetime,@EndTime datetime
set @RDate='2005-12-1'
set @EndTime='2005-12-31'
while @RDate<=@EndTime
begin
insert #t
select @RDate
set @RDate=dateadd(d,1,@RDate) --加一天
end--用cross join 完成插入
insert zzz
select a.ClassNo,b.date_time
from ClassInfo a cross join #t b