SQL 执行插入1000万条数据操作几十秒内!

最新推荐文章于 2024-05-03 12:59:44 发布

转载最新推荐文章于 2024-05-03 12:59:44 发布 · 2.5k 阅读

文章标签：

#sql #database #go #c

SQL 专栏收录该内容

3 篇文章

订阅专栏

本文演示了SQL语句的使用，包括修改数据库恢复模式为BULK_LOGGED，并通过多表联接创建一个复合ID的插入操作。此外，介绍了如何将数据库恢复模式设置为FULL模式，用于更严格的事务一致性控制。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

alter database test set recovery BULK_LOGGED
go
insert into aaa
select id=a.id+b.id+c.id+d.id +e.id +f.id+g.id
from(
select id=0 union all select 1
union all select id=2 union all select 3
union all select id=4 union all select 5
union all select id=6 union all select 7
union all select id=8 union all select 9
) a,(
select id=0 union all select 10
union all select id=20 union all select 30
union all select id=40 union all select 50
union all select id=60 union all select 70
union all select id=80 union all select 90
) b,(
select id=0 union all select 100
union all select id=200 union all select 300
union all select id=400 union all select 500
union all select id=600 union all select 700
union all select id=800 union all select 900
) c,(
select id=0 union all select 1000
union all select id=2000 union all select 3000
union all select id=4000 union all select 5000
union all select id=6000 union all select 7000
union all select id=8000 union all select 9000
) d,(
select id=0 union all select 10000
union all select id=20000 union all select 30000
union all select id=40000 union all select 50000
union all select id=60000 union all select 70000
union all select id=80000 union all select 90000
) e,(
select id=0 union all select 100000
union all select id=200000 union all select 300000
union all select id=400000 union all select 500000
union all select id=600000 union all select 700000
union all select id=800000 union all select 900000
)f,(
select id=0 union all select 1000000
union all select id=2000000 union all select 3000000
union all select id=4000000 union all select 5000000
union all select id=6000000 union all select 7000000
union all select id=8000000 union all select 9000000
)g

go

alter database test set recovery full