2,495
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
hunter8888 2005-05-29
- 打赏
- 举报
insert into yourtable (select yourfield from yourothertable)
或者
insert into yourtable (1,2,3,4)
(select 5 as 1,6 as 2,7 as 3,8 as 4 from yourothertable)
或者
insert into yourtable (1,2,3,4)
(select 5 as 1,6 as 2,7 as 3,8 as 4 from yourothertable
unoin
select 5 as 1,6 as 2,7 as 3,8 as 4 from yourothertable
unoin
select 5 as 1,6 as 2,7 as 3,8 as 4 from yourothertable
.......
)
看一看这些符合你的要求吗?
)
或者
insert into yourtable (1,2,3,4)
(select 5 as 1,6 as 2,7 as 3,8 as 4 from yourothertable)
或者
insert into yourtable (1,2,3,4)
(select 5 as 1,6 as 2,7 as 3,8 as 4 from yourothertable
unoin
select 5 as 1,6 as 2,7 as 3,8 as 4 from yourothertable
unoin
select 5 as 1,6 as 2,7 as 3,8 as 4 from yourothertable
.......
)
看一看这些符合你的要求吗?
)
guolvguolv 2005-05-29
- 打赏
- 举报
向数据库里插入多行数据怎么写???请说明白是插入相同的做测试用还是做什么用，楼上的是插入100行的存储过程
78hgdong 2005-05-29
- 打赏
- 举报
循环插入100条记录:
declare @bb int
set @bb=1
while @bb<100
begin
insert into table1 values(@bb,....)
set @bb=@bb+1
end
declare @bb int
set @bb=1
while @bb<100
begin
insert into table1 values(@bb,....)
set @bb=@bb+1
end
