将表 自增长列 清零 循环插入时间自增长

DBCC CHECKIDENT('表名', RESEED, 0)

declare @i int
set @i=1
while @i<=24
begin

INSERT INTO [ZHJF].[dbo].[HJ_DailyVal]
           ([VariableID]
           ,[CollectTime]
           ,[VariableValue])
     VALUES
           ('A0013'
           ,DATEADD(HOUR,@i,'2012-01-12 00:00:00')
           ,@i)
           set @i=@i+1
end

结果：

1	A0013	2012-01-12 01:00:00.000	1.00
2	A0013	2012-01-12 02:00:00.000	2.00
3	A0013	2012-01-12 03:00:00.000	3.00
4	A0013	2012-01-12 04:00:00.000	4.00
5	A0013	2012-01-12 05:00:00.000	5.00
6	A0013	2012-01-12 06:00:00.000	6.00
7	A0013	2012-01-12 07:00:00.000	7.00
8	A0013	2012-01-12 08:00:00.000	8.00
9	A0013	2012-01-12 09:00:00.000	9.00
10	A0013	2012-01-12 10:00:00.000	10.00
11	A0013	2012-01-12 11:00:00.000	11.00
12	A0013	2012-01-12 12:00:00.000	12.00
13	A0013	2012-01-12 13:00:00.000	13.00
14	A0013	2012-01-12 14:00:00.000	14.00
15	A0013	2012-01-12 15:00:00.000	15.00
16	A0013	2012-01-12 16:00:00.000	16.00
17	A0013	2012-01-12 17:00:00.000	17.00
18	A0013	2012-01-12 18:00:00.000	18.00
19	A0013	2012-01-12 19:00:00.000	19.00
20	A0013	2012-01-12 20:00:00.000	20.00
21	A0013	2012-01-12 21:00:00.000	21.00
22	A0013	2012-01-12 22:00:00.000	22.00
23	A0013	2012-01-12 23:00:00.000	23.00
24	A0013	2012-01-13 00:00:00.000	24.00