如何把a表中的内容复制到b表中

[frank_77]

现有两个表，a和b，a表中有两个字段，id和name,b表中也有两个字段，id和name，用两个表的id作对应，如何把a表中的name字段的内容复制到b表中

[TedZhou]

用DTS

[hjb111]

insert into b select * from a

[CrazyFor]

复制表(只复制结构,源表名：a 新表名：b)
SQL: select * into b from a where 1<>1

拷贝表(拷贝数据,源表名：a 目标表名：b)
SQL: insert into b(a, b, c) select d,e,f from b;

[workhand]

update b set name = c.name from a c where b.id = c.id


insert insert into b select * from a where a.id not in(select distinct id from b)

[foxstarx]

如果你饿id列是identity的话，就该在执行以前执行下面的语句
set identity_insert on
然后insert，最后还有执行下面的语句
set identity_insert off

[zjcxc]

update b set name=a.name
from a,b where a.id=b.id