摘要: 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 阅读全文
posted @ 2011-12-28 14:59 荣景智工 阅读(281) 评论(0) 推荐(0) 编辑