1, 循环执行,sql server 操作。
DECLARE @i INT=0
WHILE @i<400 BEGIN
INSERT INTO dt2
(
[name]
,[value]
,[value2])
VALUES
(
'name'+CAST( @i AS NVARCHAR(50)),
ABS(CHECKSUM(NewId())) % 15,
ABS(CHECKSUM(NewId())) % 10
)
SET @i=@i+1
WAITFOR DELAY '00:00:00.001';
END
go