insert into people([name],age) select [name],age from table-name
declare @temppeople table( name varchar(50) ,age int) insert into @temppeople values ( '张三',12) insert into @temppeople values ( '李思',21) insert into @temppeople values ( '网五',22) insert into people select * from @temppeople
declare @temppeople table( name varchar(50) ,age int) insert into @temppeople select '张三',12 union all select '李思',21 union all select '网五',22
name varchar(50)
,age int)
insert into @temppeople values ( '张三',12)
insert into @temppeople values ( '李思',21)
insert into @temppeople values ( '网五',22)
insert into people
select * from @temppeople
declare @temppeople table(
name varchar(50)
,age int)
insert into @temppeople
select '张三',12
union all select '李思',21
union all select '网五',22