sql语句循环
发布网友
发布时间:2022-04-26 05:06
我来回答
共1个回答
热心网友
时间:2022-04-09 05:41
insert into Term (WeekID WeekBeginTime WeekEndTime)
select
id,dateadd(d,(id-1)*7,'2011/9/5'),dateadd(d,(id-1)*7+6,'2011/9/5')
from
(select top (datediff(WEEK,'2011/9/5','2011/12/1')+1) ROW_NUMBER() over(order by a.id) as ID from syscolumns a,syscolumns b ) aa