INSERT INTO B(B1,B2) SELECT A1,A2 FROM A楼主 不理解的话 最好看看sql 帮助 文档
SET NOCOUNT ON INSERT INTO B(B1,B2) SELECT A1,A2 FROM A SET NOCOUNT OFF
insert into B select A1,A2 From A
insert into B(b1,B2) SELECT A1,A2 FROM a这样..
两种方法: 1.insert into B(b1,B2) SELECT A1,A2 FROM a 2.SELECT A1,A2 into B FROM a ------------------------ http://fenglin.xland.cn ------------------------
说明:拷贝表(拷贝数据,源表名:a 目标表名:b) insert into b(a, b, c) select d,e,f from b;
INSERT INTO B(B1,B2) SELECT A1,A2 FROM A楼主 不理解的话 最好看看sql 帮助 文档
INSERT INTO B(B1,B2) SELECT A1,A2 FROM A
SET NOCOUNT OFF
1.insert into B(b1,B2) SELECT A1,A2 FROM a
2.SELECT A1,A2 into B FROM a
------------------------
http://fenglin.xland.cn
------------------------
insert into b(a, b, c) select d,e,f from b;
送分就接个