SQL用例:convert(),while,Dateadd()

 

use [Test]
delete [DateString]
insert into [DateString] values('asdf',convert(datetime,'1990-12-19'),0)

declare @i int
set @i=1
while @i<30
begin
insert into [DateString]
values(
	'aa',
	Dateadd(day,@i,convert(datetime,'1990-12-19')),
	@i)
set @i=@i+1
end

asdf	1990-12-19 0:00:00	0
aa	1990-12-20 0:00:00	1
aa	1990-12-21 0:00:00	2
aa	1990-12-22 0:00:00	3
aa	1990-12-23 0:00:00	4
aa	1990-12-24 0:00:00	5
aa	1990-12-25 0:00:00	6
aa	1990-12-26 0:00:00	7
aa	1990-12-27 0:00:00	8
aa	1990-12-28 0:00:00	9
aa	1990-12-29 0:00:00	10
aa	1990-12-30 0:00:00	11
aa	1990-12-31 0:00:00	12
aa	1991-1-1 0:00:00	13
aa	1991-1-2 0:00:00	14
aa	1991-1-3 0:00:00	15
aa	1991-1-4 0:00:00	16
aa	1991-1-5 0:00:00	17
aa	1991-1-6 0:00:00	18
aa	1991-1-7 0:00:00	19
aa	1991-1-8 0:00:00	20
aa	1991-1-9 0:00:00	21
aa	1991-1-10 0:00:00	22
aa	1991-1-11 0:00:00	23
aa	1991-1-12 0:00:00	24
aa	1991-1-13 0:00:00	25
aa	1991-1-14 0:00:00	26
aa	1991-1-15 0:00:00	27
aa	1991-1-16 0:00:00	28
aa	1991-1-17 0:00:00	29
NULL	NULL	NULL