怎样往一个表里插入一段日期值？（2000-01-01---2010-12-31）

[xueyinian]

怎样往一个表里插入一段日期值？（2000-01-01---2010-12-31）
用sql语句生成

[daijingjie2002]

CREATE TABLE TEST
(
A DATETIME
)
GO
declare @date1 datetime,
@date2 datetime
set @date1 = '2000-01-01'
set @date2 = '2010-12-31'
while(@date1 <= @date2)
begin
insert into test select @date1
set @date1 = @date1
end

[Softlee81307]

下面執行過程fk 就可
Create table c(bb datetime )

-----------------
Create proc fk
@begin datetime,
@end datetime
as
declare @fk datetime
truncate table c ------ 刪除c表數據 這裡要不要據樓主的需要
if @begin>@end
begin
set @fk=@begin
set @begin=@end
set @end=@fk
end
set @fk=@begin
while @fk<=@end
begin
insert into c(bb) select @fk
set @fk=dateadd(dd,1,@fk)
end
select * from c
----------------輸出結果----------

exec fk '2010-12-31','2000-01-01'

drop proc fk

[xluzhong]

CREATE TABLE TEST
(
A DATETIME
)
GO

declare @date1 datetime
declare @date2 datetime

set @date1 = cast('2000-01-01' as datetime)
set @date2 = cast('2010-12-31' as datetime)

while(@date1 <= @date2)
begin
insert into test select @date1
set @date1 = dateadd(day,1,@date1)
end

[skyboy0720]

CREATE TABLE TEST
(
A DATETIME
)
GO
INSERT TEST SELECT '2000-1-1'
GO
SELECT * FROM TEST

[skyboy0720]

理解错了！

[子陌红尘]

CREATE TABLE TEST
(
A DATETIME
)
GO

declare @date1 datetime
declare @date2 datetime

set @date1 = cast('2000-01-01' as datetime)
set @date2 = cast('2010-12-31' as datetime)

while(@date1 <= @date2)
begin
insert into test select @date1
set @date1 = dateadd(day,1,@date1)
end

[mschen]

declare @start varchar(10)
set @start='2000-01-01'
declare @riqi varchar(23)
set @riqi=@start+'---'+cast(dateadd(yy,10,convert(@start,datetime,101)))
insert into 表(字段) values(@riqi)

[pbsql]

select top 4018 id=identity(int,0,1) into #t from syscolumns a,syscolumns b
insert into 表(列名)
select dateadd(day,id,'2000-1-1') from #t
drop table #t

[skyboy0720]

楼主可能想要一条SQL语句那种！

[skyboy0720]

风云的方法应该是最简单了！