SQL Server数据库怎么用sql语句同时插入一亿条数据?(存储过程也行)

发布网友发布时间：2022-04-11 15:42

共6个回答

热心网友时间：2022-04-11 17:11

要想同时插入必须通过线程才能实现并发，大体代码如下：
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();
}
}

}

}

热心网友时间：2022-04-11 18:29

写个循环就ok 了

declare @Count int=10000000000---设置你想插入的条数
while @Count>0
begin
insert into users values ('测试',@Count)
set @Count = @Count-1
end

热心网友时间：2022-04-11 20:04

写个循环，把要插入的做的循环，或者用批处理

热心网友时间：2022-04-11 21:55

create table tb(num int)
insert into tb values(1)
go 100000000

热心网友时间：2022-04-12 00:03

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

热心网友时间：2022-04-12 02:28

批量导入