1.往表中插入一年的日期
create table testdatetime (日期 datetime)
go
declare @i datetime
set @i= dateadd(d,1-datepart(dy,getdate()),getdate())
declare @year int
set @year=datepart(yy,@i)
while(@year=datepart(yy,@i))
begin
insert into testdatetime values(@i)
set @i=dateadd(d,1,@i)
end
select * from testdatetime
drop table testdatetime
2.往表中插入指定时间段的日期
create table testdatetime (日期 datetime)
declare @BeginDate datetime
declare @EndDate datetime
set @BeginDate= '2008-10-05'
set @EndDate= '2008-12-05'
declare @month int
set @month=datepart(mm,@EndDate)
while(@BeginDate<[email=[ft=#595b48,,]=@EndDate]=@EndDate[/email] )
begin
insert into testdatetime values(@BeginDate)
set @BeginDate=dateadd(d,1,@BeginDate)
end
select * from testdatetime
drop table testdatetime
create table testdatetime (日期 datetime)
go
declare @i datetime
set @i= dateadd(d,1-datepart(dy,getdate()),getdate())
declare @year int
set @year=datepart(yy,@i)
while(@year=datepart(yy,@i))
begin
insert into testdatetime values(@i)
set @i=dateadd(d,1,@i)
end
select * from testdatetime
drop table testdatetime
2.往表中插入指定时间段的日期
create table testdatetime (日期 datetime)
declare @BeginDate datetime
declare @EndDate datetime
set @BeginDate= '2008-10-05'
set @EndDate= '2008-12-05'
declare @month int
set @month=datepart(mm,@EndDate)
while(@BeginDate<[email=[ft=#595b48,,]=@EndDate]=@EndDate[/email] )
begin
insert into testdatetime values(@BeginDate)
set @BeginDate=dateadd(d,1,@BeginDate)
end
select * from testdatetime
drop table testdatetime