27,579
社区成员
发帖
与我相关
我的任务
分享
select top 30 id=identity(int,0,1) into #
from syscolumns,sysobjects
insert into table1
select 1,dateadd(day,id,'2007-11-01'),'数据库',5
from #
drop table #
/*
时间累加插入表中
*/
create table #t([id] int,[date] datetime,dbname varchar(16),num int)
declare @enddate datetime
declare @date datetime
set @enddate='2008-12-01' --通过改变这两个变量设置插入时间的范围
set @date='2007-11-1'
while datediff(Month,@date,@enddate)>0
begin
insert into #t values(1,@date,'数据库',5)
set @date=dateadd(day,1,@date)
end
select * from #t
drop table #t
--sysreferences的colid最大是41,如果插入超过1个月的数据,自己构造一个id列表。
select top 50 id=identity(int,0,1) into #T from syscolumns,sysobjects
insert into table1 select 1,dateadd(day,id,'2007-11-01'),'数据库',5 from #T
drop table #T
insert into table1 select top 30 1,dateadd(day,colid-1,'2007-11-01'),'数据库',5 from syscolumns where id=object_id('sysreferences') order by colid
insert into table1 select top 30 1,dateadd(day,colid-1,'2007-11-01'),'数据库',5 from syscolumns where id=object_id('sysreferences')