declare @start date,@end date;set @start=‘2010-01-01‘;set @end=‘2010-02-01‘;--获取时间段内日期列表select  [day]=dateadd(day, number - 1, @start)from master.dbo.spt_valueswhere type=‘P‘ and number <= datediff(day, @start,@end) + 1and number>0