摘要:
create table #temp(ids int identity(1,1), 日期 nvarchar(10))declare @beginDate datetimedeclare @endDate datetimeset @beginDate = '2009-06-01' set @endDate = '2009-06-10'declare @i intset @i = 0while @i <=datediff(DD,@beginDate,@endDate)begininsert into #tempselect convert(nvarchar(1 阅读全文