update table1 set table1.[field] = table2.[field]
from table1,table2
where table1.field1 = table2.field1
and table1.field2 = table2.field2
... ...(除field外的所有字段)
from table1,table2
where table1.field1 = table2.field1
and table1.field2 = table2.field2
... ...(除field外的所有字段)
set columnname=a.column
from tableA a
where tableB.id=a.id
set @n=(select top 1 id from table1 where id='条件'
insert into table2(id) values(@n)
set table1.[field] = table2.[field]
from table1
join table2
on table1.field1 = table2.field1
[ and table1.field2 = table2.field2]//可选
[...]//可选
from table2
where table1.field1 = table2.field1
set columnname=a.column
from tableA a
where tableB.id=a.id