Insert 1000条记录

[bobo740]

要做系统性能测试
向数据库中各个表中添加1000条记录

SQL语句怎么写：

例如：
表名:project
字段：id name parentID
请教各位

[chd2001]

不是太明白？？！！已有记录插入吗？

[bobo740]

无有，要自己new

[lsxaa]

declare @i int

set @i=1000
while @i<1000
insert into project select 'id','name','parintid'
set @i=@i+1
end

[lsxaa]

declare @i int

set @i=1000
while @i<1000
insert into project select 'id','name','parintid'
set @i=@i-1 减1
end

[lsxaa]

declare @i int

set @i=1000
while @i>0
insert into project select 'id','name','parintid'
set @i=@i-1
end



declare @i int

set @i=0
while @i<1000
insert into project select 'id','name','parintid'
set @i=@i+1
end

[xwdxwd]

insert into project (id,name,parentID)
values('','','')
where max(id) <=1000

在这里我将id 设置成自动增长的

[freddy2003]

declare
@counter int,
@str_var varchar(10)
set @counter=1
while @counter<1001
begin
insert into t6 (id,name,parentID) values (@counter,'Name',12)
set @counter=@counter+1
end

[txlicenhe]

insert into project select top 1000 colid,name,id from sysobjects
order by colid

[long111]

学习

[TT008]

study