22,210
社区成员
发帖
与我相关
我的任务
分享
--循环插入大量数据
declare @i int
set @i = 0
while(@i < 10000)
begin
insert info(info_title, info_content, state)
select top 1 info_title, info_content, state from info
set @i = @i + 1
end
--循环插入大量数据
declare @i int
set @i = 0
while(@i < 10000)
begin
insert info(info_title, info_content, state)
select top 1 info_title, info_content, state from info
set @i = @i + 1
end
--截断日志
backup log test with no_log
dbcc shrinkfile (test_log, 1)