在mssqlserver中循环SELECT语句[重复]-LoopinginSELECTstatementinmssqlserver[duplicate]

10  

That will give you a resultset for each loop iteration as you select per iteration.

每次迭代选择时，这将为每个循环迭代提供结果集。

If you want a single resultset insert into a temp table/variable per iteration then select from it or

如果您希望每次迭代将单个结果集插入临时表/变量，则从中选择或

;with T(day) as
(
    select @startDate as day
        union all
    select day + 1
        from T
        where day <@endDate
)
select day as [Date] from T

2  

If you want to use a WHILE loop:

如果要使用WHILE循环：

declare @startDate datetime , @endDate datetime
set @startDate='09/01/2012'
set @endDate='09/30/2012'

create table #temp (startDate datetime)   

while @startDate <= @endDate
    begin
        insert into #temp
        select @startDate as Date
        set @startDate = DATEADD(day,1,@startDate)
    end

select *
from #temp

drop table #temp

0  

You could create a temp table for the values and select from that in the end, after the iteration.

您可以为值创建临时表，并在迭代后从最后选择。

declare @temp table (TheDate date)

declare @startDate datetime , @endDate datetime
set @startDate='09/01/2012'
set @endDate='09/30/2012'

while DATEDIFF(day, @startDate, @endDate)!=-1
begin
insert into @temp (thedate) values (@startDate)
set @startDate = DATEADD(day,2,@startDate)
end
select * from @temp

edit: The cte Alex suggest is imo a much cleaner way to do it, and more of a sql way to do it, without using loops or cursors.

编辑：亚历克斯建议使用更简洁的方法，以及更多的sql方式，而不使用循环或游标。