MSSQL操作

1.两个数据库之间数据表的复制:

select * into [dbnameA]..[tablenameA] from [dbnameB]..[tablenameB]

2.同一数据库之间数据表的复制

新表不存在:select * into b from a;

新表存在:insert into b select * from a

3.不同数据库之间数据表的复制

新表不存在:select * into [DBA].[dbo].[TableA] from [DBB].[dbo].[TableA]

4.将一张表中的字段更新到另一张表

update A
set A.Section=B.[Section]
from TableA as A 
join TableB as B 
on A.ID=B.ID