select 日期字段名 into 新表名 from 表名 where 日期字段名>='2006-1-2' and 日期字段名 <= '2006-1-21' order by 日期字段名--如果日期字段名中数据有重复 select 日期字段名 into 新表名 from 表名 where 日期字段名>='2006-1-2' and 日期字段名 <= '2006-1-21' group by 日期字段名 order by 日期字段名
declare @dt1 datetime, @dt2 datetime select @dt1='2006-1-12', @dt2='2006-1-21'WHILE @dt1<=@dt2 begin insert tb values(@dt1) set @dt1=@dt1+1 end
create table ttt(id1 int identity(1,1),b datetime) declare @a datetime,@b datetime,@c int select @a='2006-1-2',@b='2006-1-21' set @c=datediff(dd,cast(@a as datetime),cast(@b as datetime))+1 --日期差exec('insert ttt(b) select top '+ @c +' '''+@a+''' from syscolumns a') update ttt set b=dateadd(dd,id1-1,cast(b as datetime)) select * from ttt drop table ttt
declare @dt1 datetime, @dt2 datetime select @dt1='2006-1-12', @dt2='2006-1-21'WHILE @dt1<=@dt2 begin insert tb values(@dt1) set @dt1=dateadd(dd,@dt1,1) end
declare @tab table(dat datetime)select * from @tabdeclare @BegD datetime declare @EndD datetime set @BegD='2006-01-01' set @EndD='2006-01-12'declare @da datetime set @da=@BegD while @da<=@EndD begin insert @tab values(@da) set @da=dateadd(day,1,@da) end select * from @tab
select @dt1='2006-1-12',
@dt2='2006-1-21'WHILE @dt1<=@dt2
begin
insert tb values(@dt1)
set @dt1=@dt1+1
end
declare @a datetime,@b datetime,@c int
select @a='2006-1-2',@b='2006-1-21'
set @c=datediff(dd,cast(@a as datetime),cast(@b as datetime))+1 --日期差exec('insert ttt(b) select top '+ @c +' '''+@a+''' from syscolumns a')
update ttt set b=dateadd(dd,id1-1,cast(b as datetime))
select * from ttt
drop table ttt
select @dt1='2006-1-12',
@dt2='2006-1-21'WHILE @dt1<=@dt2
begin
insert tb values(@dt1)
set @dt1=dateadd(dd,@dt1,1)
end
declare @EndD datetime
set @BegD='2006-01-01'
set @EndD='2006-01-12'declare @da datetime
set @da=@BegD
while @da<=@EndD
begin
insert @tab values(@da)
set @da=dateadd(day,1,@da)
end
select * from @tab