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

来源：互联网发布：url域名网站 ip的区别编辑：程序博客网时间：2024/04/30 09:18

use [Test]delete [DateString]insert into [DateString] values('asdf',convert(datetime,'1990-12-19'),0)declare @i intset @i=1while @i<30begininsert into [DateString]values('aa',Dateadd(day,@i,convert(datetime,'1990-12-19')),@i)set @i=@i+1end

asdf 1990-12-19 0:00:000aa 1990-12-20 0:00:001aa 1990-12-21 0:00:002aa 1990-12-22 0:00:003aa 1990-12-23 0:00:004aa 1990-12-24 0:00:005aa 1990-12-25 0:00:006aa 1990-12-26 0:00:007aa 1990-12-27 0:00:008aa 1990-12-28 0:00:009aa 1990-12-29 0:00:0010aa 1990-12-30 0:00:0011aa 1990-12-31 0:00:0012aa 1991-1-1 0:00:0013aa 1991-1-2 0:00:0014aa 1991-1-3 0:00:0015aa 1991-1-4 0:00:0016aa 1991-1-5 0:00:0017aa 1991-1-6 0:00:0018aa 1991-1-7 0:00:0019aa 1991-1-8 0:00:0020aa 1991-1-9 0:00:0021aa 1991-1-10 0:00:0022aa 1991-1-11 0:00:0023aa 1991-1-12 0:00:0024aa 1991-1-13 0:00:0025aa 1991-1-14 0:00:0026aa 1991-1-15 0:00:0027aa 1991-1-16 0:00:0028aa 1991-1-17 0:00:0029NULLNULLNULL