Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @Counter int
- SET @Counter = 0
- DECLARE @Lenght int
- SET @Lenght = 2000 --[0..2047]
- -- Добавляем числа в таблицу
- WHILE @Counter < 10000000
- BEGIN
- INSERT dbo.[Random Numbers]
- SELECT
- -- Создаем случайные числа
- ABS(CHECKSUM(NewId())) % 100000 AS Result
- -- Список чисел [0..@Lenght]
- FROM master..spt_values
- WHERE spt_values.type = 'P' AND number < @Lenght
- -- Количество добавленных строк
- SET @Counter = @Counter + @Lenght
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement