Select Top 8000 identity(Int,1,1) As id Into # from syscolumns a, syscolumns b
Declare @BeginDate DateTime
Declare @EndDate DateTime
Select @BeginDate='2006-05-05',@EndDate='2006-06-06'
Select DateAdd(dd,id-1,@BeginDate) From # Where ID<=DateDiff(dd,@BeginDate,@EndDate)+1
Drop Table #
declare @EndDate datetime
SELECT @BeginDate='2006-05-05 00:00:00',@EndDate='2006-06-06 00:00:00'
--create table d(fdate datetime)
while datediff(day,@BeginDate,@EndDate)>=0
begin
insert d values(@BeginDate)
select @BeginDate=dateadd(day,1,@Begindate)
endselect * from dselect * from d
declare @EndDate datetime
SELECT @BeginDate='2006-05-05',@EndDate='2006-06-06'
while @BeginDate<=@EndDate
begin
insert d values(@BeginDate)
select @BeginDate=dateadd(day,1,@Begindate)
endselect * from ddrop table d
select identity(int,0,1) as id into # from sysobjects a,sysobjects b
set rowcount 0
declare @BeginDate as datetime,
@EndDate as datetime
SELECT @BeginDate='2006-05-05 00:00:00',@EndDate='2006-06-06 00:00:00'
Select DateAdd(dd,id-1,@BeginDate)
From # Where
ID<=DateDiff(dd,@BeginDate,@EndDate)+1
drop table #