22,209
社区成员
发帖
与我相关
我的任务
分享
declare @i int
declare @count int
declare @dt date
declare @str varchar(100)
declare @next int
begin
set @i = 1
set @count = 1
set @dt = GETDATE()
while @i <= 300000000
begin
if(@count >1000)
begin
set @dt = DateAdd(dd,-1,@dt)
set @count = 1
end
insert into [T_Action](Name,ActionTime)values('MyName'+convert(varchar,@i),@dt)
set @i = @i + 1
set @count = @count + 1
end
end