一次性插放几千条记录如何做

[ctz]

id为自动增加
username无论什么都可以 相同
用SQL查询分析句要用什么语句

[DeltaCat]

declare @i int
for @i=0 to 9999
insert into table values ('user' + cast(@i as varchar(4)))
next

[lbd8848]

declear @i smallint
set @i=1
while @i<=1000
begin
insert into table(id,username) vlaues(1,'11')
set @i=@i+1
end

[chenxingbai]

上面这位兄弟写的不对
declare @i int
set @i=9999
while @i>=0
begin
insert into tablename(username) values ('user' + cast(@i as varchar(4)))
set @i=@i-1
end

[xiaoyuehen]

insert into mytest_temp select top 10 ('user' + cast(rand()*10 as varchar(10))) from syscolumns

[潜水的鱼]

declare @i int
set @i=9999
while @i>=0
begin
insert into tablename(username) values (11)
set @i=@i-1
end

插入10000条username值为11的记录

^_^

[xiaoyuehen]

补充一下..上述语句只能插入相同的10语句...以下这句可以正常(每条语句值不同):

select distinct top 10 ('user' + cast(id as varchar(10))) from syscolumns

[xiaoyuehen]

呵呵...漏了一些...

insert into mytest_temp select distinct top 10 ('user' + cast(id as varchar(10))) from syscolumns

[xeimm]

access 我是直接粘贴~~~ 呵呵 帮你顶~~~

[fkphp]

for i=1 to 9999999
sql="insert into table(id,username) vlaues('','name"&i&"')"
conn.execute(sql)
next

[ctz]

在查询器里如何执行啊