如何在存储过程中将一个查询到的多条记录插入到另外一个表中？

[ahlegend]

建立一个存储过程，将符合条件的所有记录插入到另外一个表当中。

[vivianfdlpw]

create procedue p
as
insert 另一表(字段1，字段2........)
select 字段1，字段2.......
from 表
where ......
go

[lxzm1001]

create proc procname
as
insert tablename(colname,colname,colname)
select col1name,col2name,col3name from othertablename where ....

[zlp321002]

--right

[zyfire88]

create proc P
as
select * into 另一个表名 from 原表 where 条件

[ReViSion]

都说完了呀，收工

[MorningTea]

都可以！！！

也可以放在
create proc procname
as
select col1name,col2name,col3name from tablename

go
insert tablename2 (colname,colname,colname)
exec procname

select * from tablename2/*察看结果*/

[diren]

我能不能这么做

create proc procname
as
insert tablename(colname,colname,colname)
select col1name,col2name,col3name from othertablename where ....

insert tablename2 (colname,colname,colname)
select col1name,col2name,col3name from tablename

注意insert tablename2 是 from tablename

[khyhli]

create proc Procedurename
as
select * into 另一表 from 原表 where 条件