select dateadd(dd,num,@start) as date11
FROM (SELECT ROW_NUMBER() OVER (ORDER BY ID)-1 AS num FROM sysobjects) KK
where dateadd(dd,num,@start) <=@end
ORDER BY date11 desc
有段日期内所有天数
最新推荐文章于 2022-05-04 11:49:12 发布
select dateadd(dd,num,@start) as date11
FROM (SELECT ROW_NUMBER() OVER (ORDER BY ID)-1 AS num FROM sysobjects) KK
where dateadd(dd,num,@start) <=@end
ORDER BY date11 desc