Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Declare @parentId int
- declare @suffix nvarchar(32)
- Declare @count int
- Set @count = 1
- While @count <= 10
- Begin
- -- получаем короткую случайную подстроку для названия
- set @suffix =LEFT(NEWID(),4)
- -- получаем случайный внешний ключ из родительской таблицы
- SELECT @parentId = id FROM ( SELECT id, ROW_NUMBER () OVER (ORDER BY id) AS RowNum FROM pb_categories) t1
- WHERE RowNum = (select Round(count(*) * rand(),0) from pb_categories)
- Print @parentId
- -- создаем запись
- insert into pb_categories (name, parentID, ord, [desc], isDisabled)
- values ('category '+ @suffix, @parentId, @count, @suffix, '0')
- Set @count = @count + 1
- End
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement