create table datetimes
(
id int not null primary key identity(1,1),
dates datetime not null
)要求向数据库表中插入100给随机日期或随机时间,
哪位大哥帮帮忙!!!
(
id int not null primary key identity(1,1),
dates datetime not null
)要求向数据库表中插入100给随机日期或随机时间,
哪位大哥帮帮忙!!!
调试欢乐多
用一個臨時表記錄取值,每次用Order by newID()+Top 1,取一次在表刪除對應記錄或用newID()--轉換取
DECLARE @I INT
SELECT @I=1
WHILE @I<=100
BEGIN
INSERT INTO DATETIMES(DATES) SELECT SELECT CAST(ABS(checksum(NEWID()))%3012153-53690 AS DATETIME)
SELECT @I=@I+1
END
TOP 100
ROW_NUMBER()OVER(ORDER BY a.ID) AS ID,
CAST(CHECKSUM(newID())%40357 AS DATETIME)+RAND() AS 隨機值
FROM syscolumns a,syscolumns b舉個例子給樓主
SET @BDate = '20090101' --下限
SET @EDate = '20101231 23:59:59' --上限
SELECT n, random_datetime = DATEADD(second,ABS(CHECKSUM(NEWID()))%DATEDIFF(second,@BDate,@Edate),@BDate)
FROM dbo.Nums
WHERE n BETWEEN 1 AND 100