将一张表中的部分记录插入到另一张表中

create table  #a 
(
   ID INT,
   CODE varchar(100),
   Name varchar(100),
)

insert #a 
select 1,'a','扬子江'
union all
select 2,'a','扬子江'
union all
select 3,'a','扬子江'
union all
select 3,'a','黄浦江'
union all
select 3,'a','澜沧江江'

select * from #a 


create table  #b
(
   ID INT,
   CODE varchar(100),
   Name varchar(100),
)
insert into #b(ID,CODE,Name) select ID,'b',Name from #a where Name='扬子江'

select * from  #b