1、ceiling(rand() * 15) 可生成1-15随机数
2、DATEADD(second,ABS(CHECKSUM(NEWID()))%DATEDIFF(second,'20160501' ,‘20161231’),'20160501') 生成'20160501' -‘20161231’之间随机时间
3、模拟插入数据库数据
DECLARE @BDate datetime, @EDate datetime,@id int,@i int
SET @BDate = '20160501'SET @EDate = '20161231 23:59:59' --时间区间
set @i = 1
while @i<100
begin
set @id = ceiling(rand() * 15) -- 1-15随机数
insert into dt_游览记录表(id,传感器ID,时间) values(@i,@id,convert(varchar(100), DATEADD(second,ABS(CHECKSUM(NEWID()))%DATEDIFF(second,@BDate,@Edate),@BDate),120))
set @i = @i+1
end