34,593
社区成员
发帖
与我相关
我的任务
分享
declare @dt datetime,@i int,@dt1 datetime
set @dt='2010-3-25'
set @i=30
while @dt1<'2010-6-21 16:00:00'
begin
set @dt1=dateadd(mi,@i,@dt)
set @i=@i+30
end
select @dt1 as sDatetime
declare @dt datetime,@i int,@dt1 datetime
set @dt='2010-3-25'
set @i=30
select @dt1
while @dt<'2010-3-25 16:00:00'
begin
set @dt=dateadd(mi,@i,@dt)
set @i=@i+30
set @dt1=@dt
end
select @dt1 as sDatetime
declare @dt datetime,@i int,@dt1 datetime
set @dt='2010-3-25'
set @dt1='2010-3-25'
set @i=30
while @dt1<'2010-6-21 16:00:00'
begin
set @dt1=dateadd(mi,@i,@dt)
set @i=@i+30
--print @i
end
select @dt1 as sDatetime
declare @dt datetime,@i int,@dt1 datetime
set @dt='2010-3-25'
set @i=20
set @dt1=dateadd(mi,@i,@dt)
while @dt1<'2010-6-21 16:00:00'
begin
set @i=@i+20
set @dt1=dateadd(mi,@i,@dt)
select @dt1
end
declare @dt datetime,@dt1 datetime
set @dt='2010-3-25'
set @dt1='2010-6-21 16:00:00'
select
dateadd(dd,rn,@dt)
from
(select top 100000 rn=row_number() over(order by getdate()) from sys.columns,sys.objects) b
where
dateadd(dd,rn,@dt)<=@dt1
declare @dt datetime,@i int,@dt1 datetime
set @dt='2010-3-25'
set @i=30
while @dt1<'2010-6-21 16:00:00'--这里的@dt1 是null
begin
set @dt1=dateadd(mi,@i,@dt)
set @i=@i+30
end
select @dt1 as sDatetime