最近需要用到大量数据,但是又无从获取,只好写个批量插入脚本来批量完成了,代码如下:
begin
declare @i int,@j int
declare @storeNum int
declare @T1 int,@T2 int,@O2 int,@CO2 int
declare @mytime datetime
set @i=1
set @j=1
set @storeNum=40
set @T1=0
set @T2=10
set @O2=95
set @CO2=65
set @mytime='2013-2-14 01:00:00'
while @i<8
begin
set @j=1
while @j<=@storeNum
begin
INSERT INTO [TSupervise].[dbo].[TCtrl]
([StoreNum]
,[T1]
,[T2]
,[O2]
,[CO2]
,[Time])
VALUES
(@j, @T1, @T2, @O2, @CO2, @mytime)
set @j=@j+1
end
set @mytime=dateadd(day,1,@mytime)
set @i=@i+1
set @T1=@T1+1
set @T2=@T2-1
set @O2=@O2-3
set @CO2=@CO2+3
end
end