declare @i int
set @i = 10
while @i < 5000
begin
insert into 维修 (
[经办人] ,
[客户] ,
[物件名称] ,
[随机附件] ,
[保修] ,
[维修物类别] ,
[送修类别] ,
[维修物品牌]
) values ('陈琦','鑫网','笔记本','无','保内','修品类别','用户送修','修品品牌')
set @i = @i+1
end
set @i = 10
while @i < 5000
begin
insert into 维修 (
[经办人] ,
[客户] ,
[物件名称] ,
[随机附件] ,
[保修] ,
[维修物类别] ,
[送修类别] ,
[维修物品牌]
) values ('陈琦','鑫网','笔记本','无','保内','修品类别','用户送修','修品品牌')
set @i = @i+1
end