22,210
社区成员
发帖
与我相关
我的任务
分享
--量不够自己加
DECLARE @t1 DATETIME,@t2 DATETIME
SELECT @t1='2010-05-01',@t2='2010-05-30'
SELECT TOP(1440*DATEDIFF(dd,@t1,@t2+1))
0 Column_A,
0 Column_B,
0 Column_C,
DATEADD(mi, ROW_NUMBER()OVER(ORDER BY a.id)-1, @t1) Column_D
FROM sysobjects a,sysobjects b,syscolumns c,syscolumns d
Column_A Column_B Column_C Column_D
----------- ----------- ----------- -----------------------
0 0 0 2010-05-01 00:00:00.000
0 0 0 2010-05-01 00:01:00.000
0 0 0 2010-05-01 00:02:00.000
0 0 0 2010-05-01 00:03:00.000
0 0 0 2010-05-01 00:04:00.000
。。。。。。。。
0 0 0 2010-05-30 23:56:00.000
0 0 0 2010-05-30 23:57:00.000
0 0 0 2010-05-30 23:58:00.000
0 0 0 2010-05-30 23:59:00.000
(43200 行受影响)
DECLARE @t1 DATETIME,@t2 DATETIME
SELECT @t1='2010-05-01',@t2='2010-05-30'
SELECT TOP(1440*DATEDIFF(dd,@t1,@t2+1))
0 Column_A,
0 Column_B,
0 Column_C,
DATEADD(mi, ROW_NUMBER()OVER(ORDER BY a.id)-1, @t1) Column_D
FROM sysobjects a,sysobjects b