declare @i int
declare @tab table(dayNo int)
declare @DC int
set @DC = datediff(day,'2009-02-01',dateadd(month,1,'2009-02-01'))
set @i = 0
while(@i < @DC) begin
set @i=@i+1
insert into @tab values (@i)
end
select * from @tab
declare @tab table(dayNo int)
declare @DC int
set @DC = datediff(day,'2009-02-01',dateadd(month,1,'2009-02-01'))
set @i = 0
while(@i < @DC) begin
set @i=@i+1
insert into @tab values (@i)
end
select * from @tab
生成效果贴图
![](https://pic002.cnblogs.com/img/%e5%8e%9f%e8%99%ab.july/200904/2009040310133275.jpg)
![](https://pic002.cnblogs.com/img/%e5%8e%9f%e8%99%ab.july/200904/2009040310133275.jpg)