declare @str date;
set @str='2015-01-08';
while DATEDIFF([day], @str , '2015-02-01')>0
begin
select CONVERT(varchar(100),@str, 23);
set @str=dateadd(day,1,@str)
end
declare @str date;
set @str='2015-01-08';
while DATEDIFF([day], @str , '2015-02-01')>0
begin
select CONVERT(varchar(100),@str, 23);
set @str=dateadd(day,1,@str)
end
转载于:https://www.cnblogs.com/wlzhang/p/4904374.html