用SQL语句写某一月份的日历_老陈代码记录_sql写日历

Declare 
    @Date datetime,
    @StartDate datetime,
    @EndDate datetime,
    @FirstIndex int

Set @Date ='20100610' --输入一个日期，即可算出当月的日历

Select 
    @StartDate=Convert(char(6),@Date,112)+'01', 
    @EndDate=Dateadd(month,1,@StartDate)-1,
    @FirstIndex=Datediff(day,-1,@StartDate)%7

;With t As
(
    Select Date=Convert(int,1),Row=(@FirstIndex)/7,Declare 
    @Date datetime,
    @StartDate dat