考试题目

[Aslan_]

如何用sql语句输出2005年10月29日到2005年11月01日之间的日期

[jinjazz]

select dateadd(d,i,'2005-10-29') from(select 1 as i union select 2 union select 3)a

[Aslan_]

有另外的方法吗？指定日期，而不是已知多少天的情况

[pt1314917]

select top 1000 id=identity(int,1,1) into # from sysobjects
declare @start datetime,@end datetime
set @start='2005-10-29'
set @end='2005-11-01'
select dateadd(dd,id,@start) from # 
where datediff(dd,@start,@end)>id

[sweetweiwei]

declare @a int
set @a = 1
while @a <= datediff(dd,'2005-10-29','2005-11-01')
begin
select dateadd(dd,@a,'2005-10-29')
set @a = @a +1
end

[jinjazz]

select dateadd(d,i,'2005-10-29') from(
select (select count(*) from sysobjects where id>a.id)as i from sysobjects a
)a where a.i<=datediff(d,'2005-10-29','2005-11-01')

[zanyzyg]

create table #t(dt datetime)

declare @beg datetime
declare @end datetime
set @beg='2005-10-29'
set @end='2005-11-2'
while @beg<=@end
begin
insert into #t(dt)values(@beg)
set @beg=dateadd(day,1,@beg)
end

select * from #t

drop table #t

[律己修心]

declare @tb table (dt varchar(10))
declare @startdate varchar(10)
declare @enddate varchar(10)
set @startdate='2005-10-29'
set @enddate='2005-11-01'
while cast(@startdate as datetime)<cast(@enddate as datetime)
begin
set nocount on 
set @startdate=convert(varchar(10),dateadd(day,1,@startdate),20)
if(cast(@startdate as datetime)<cast(@enddate as datetime))
insert into @tb select  @startdate
set nocount off
end
select * from @tb

[Aslan_]

SQL的循环语句做可以吗

[jinjazz]

[Quote=引用 8 楼 XSing 的回复:]
SQL的循环语句做可以吗
[/Quote]

上面这么多方法你不会自己测试么

[Aslan_]

[Quote=引用 9 楼 jinjazz 的回复:]
引用 8 楼 XSing 的回复:
SQL的循环语句做可以吗


上面这么多方法你不会自己测试么
[/Quote]网速慢，现在才看到

[srgcc]

Mark

[swot2008]

[Quote=引用 1 楼 jinjazz 的回复:]
SQL codeselect dateadd(d,i,'2005-10-29') from(select 1 as i union select 2 union select 3)a
[/Quote]

[ojuju10]

select * from tb 
where createtime between '2005-10-29' and '2005-11-01'