列出一段时间内每一天的日期

1. Declare @StartDate varchar(10)
   
2. Declare @EndDate  varchar(10)
   
3. 
   
4. SET @StartDate = '2016-05-01'
   
5. SET @EndDate = '2016-05-16'
   
6. 
   
7. Create Table #YearMonth(YM varchar(10))
   
8. While @StartDate<=@EndDate
   
9.    Begin               
   
10.      Insert Into #YearMonth(YM) Values(@StartDate)
    
11.      Set @StartDate=Convert(varchar,DATEADD(DD,1,@StartDate),23)       
    
12. End   
    
13. SELECT * FROM #YearMonth
    
14. DROP TABLE #YearMonth

复制代码

列出指定一段时间内每月的日期

1. Declare @StartDate varchar(10)
   
2. Declare @EndDate  varchar(10)
   
3. 
   
4. SET @StartDate = '2015-05-01'
   
5. SET @EndDate = '2016-06-16'
   
6. 
   
7. Create Table #YearMonth(YM varchar(10))
   
8. While @StartDate<=@EndDate
   
9.    Begin               
   
10.      Insert Into #YearMonth(YM) Values(Left(@StartDate,7)+ '-01')
    
11.    Set @StartDate=Convert(varchar,DATEADD(M,1,@StartDate),23)       
    
12. End   
    
13. SELECT * FROM #YearMonth
    
14. DROP TABLE #YearMonth

复制代码