本文介绍两种SQL批量插入数据的方法：一种是使用循环语句进行批量插入，通过设置循环次数实现特定数量的数据插入；另一种是利用子查询的方式进行数据插入，这种方法更加高效且简洁。
1.循环语句插入
[code]DECLARE @MyCounter INT
SET @MyCounter = 0 /*设置变量*/
WHILE (@MyCounter < 1000) /*设置循环次数*/
BEGIN
insert into t_campaign(t_aspaccount_id, campaign_name) values(939, '测试列表翻页')
SET @MyCounter = @MyCounter + 1
END[/code]
2.子查询插入
[code]insert into t_subcampaign(t_campaign_id, subcampaign_name) ( select t_campaign_id, campaign_name from t_campaign where campaign_name='测试列表翻页')[/code]
[code]DECLARE @MyCounter INT
SET @MyCounter = 0 /*设置变量*/
WHILE (@MyCounter < 1000) /*设置循环次数*/
BEGIN
insert into t_campaign(t_aspaccount_id, campaign_name) values(939, '测试列表翻页')
SET @MyCounter = @MyCounter + 1
END[/code]
2.子查询插入
[code]insert into t_subcampaign(t_campaign_id, subcampaign_name) ( select t_campaign_id, campaign_name from t_campaign where campaign_name='测试列表翻页')[/code]
扫一扫
856
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
