第1个回答 2011-08-16
要想同时插入必须通过线程才能实现 并发,大体代码如下:
public class TestInsert extends Thread{
public void run(){
try {
insert 语句..............
} catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
for(int i=0;i<100000;i++){
try {
new TestInsert (). start();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
第2个回答 2011-08-10
写个循环 就ok 了
declare @Count int=10000000000---设置你想插入的条数
while @Count>0
begin
insert into users values ('测试',@Count)
set @Count = @Count-1
end
第3个回答 2011-08-10
写个循环,把要插入的做的循环,或者用批处理
第4个回答 2011-08-10
create table tb(num int)
insert into tb values(1)
go 100000000本回答被提问者采纳
第5个回答 2018-07-11
CREATE TABLE number
(
number BIGINT
)
;WITH a AS
(
SELECT 0 AS n
UNION ALL
SELECT 0
),
b(n) AS
(
SELECT 1 FROM a,a AS b
)
,
c(n) AS
(
SELECT 1 FROM b,b AS c
),
d(n) AS
(
SELECT 1 FROM c,c AS d
),
e(n) AS
(
SELECT 1 FROM d,d AS e
),
f(n) AS
(
SELECT 1 FROM e,e AS f
)
,g(n) AS (
SELECT ROW_NUMBER() OVER(ORDER BY f.n) FROM f
)
INSERT INTO dbo.number
SELECT n FROM g WHERE n<=100000000