create proc a
as
begin
create table_b
(Cola,int
Colb,int
)
insert into
b(Cola,Colb)
select name,sex
from table_a
end
as
begin
create table_b
(Cola,int
Colb,int
)
insert into
b(Cola,Colb)
select name,sex
from table_a
end
create table b
(Cola int,
Colb int
)insert into
b
select [name],sex
from table_a