如果从另一个表中取insert into table(col...) select .. from othertable
insert into table1(col .....) select top N col ..... from table2
insert into table1 select top N from table2
declare @t table (ID int) --1 insert insert into @t select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select * from @t --2 insert insert into @t select ID from @tselect * from @t
select 值..... union all
select 值..... union all
select 值
--1 insert
insert into @t select 1 union all
select 2 union all
select 3 union all
select 4 union all
select 5 union all
select * from @t
--2 insert
insert into @t select ID from @tselect * from @t