一个简单的查询添加

[hys429351247]

我今天看见个题目是 先对一个表进行查询在查询的同时把值赋给另一个表 ，各位大虾们 你们谁知道 我给忘记了

[吃饱饱吖]

select * into table2
from table1

[开着拖拉机泡妞]

select * into table2 from table1
insert table1
select * fron table2

[叶子]

既能查询出来，又能插入的话，我估计是insert + output子句了。

http://www.cnblogs.com/sarahc/archive/2011/02/25/1964845.html

[zhuhailong369]

select * into table2
from table1

[Lugyedo]

insert into Table1
select 要插入到Table1的字段值 from Table 2 where 查询条件

[David8977]

----复制到一个新表,不用表结构
select * into table2 from table1

---有表结构----
insert table1
select * fron table2

[David8977]

----复制到一个新表,不用表结构
select * into table2 from table1

---有表结构----
insert table1
select * from table2

[存在666]

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

从b表查询出与a表字段id一样的行，然后更新b表的字段name赋值给a表字段name

[勿勿]

USE AdventureWorks;  

GO  

CREATE TABLE TestTable (ID INT, TEXTVal VARCHAR(100))  

DECLARE @TmpTable TABLE (ID_New INT, TEXTVal_New VARCHAR(100),ID_Old INT, TEXTVal_Old VARCHAR(100))  

INSERT TestTable (ID, TEXTVal)  VALUES (1,'FirstVal')  

INSERT TestTable (ID, TEXTVal)  VALUES (2,'SecondVal')  


UPDATE TestTable  

SET TEXTVal = 'NewValue'  

OUTPUT Inserted.ID, Inserted.TEXTVal, Deleted.ID, Deleted.TEXTVal INTO @TmpTable  

WHERE ID IN (1,2)  

  

SELECT * FROM @TmpTable  

SELECT * FROM TestTable  


DROP TABLE TestTable  

GO