MSSQL中,将表1中字段A的值赋给表2中字段B,怎么写SQL语句啊?

2024-12-31 18:21:33
推荐回答(2个)
回答1:

insert into table_a(field_a1,field_a2,field_a3) select field_b1,field_b2,field_b3) from table_b

回答2:

update 表二 set 字段B=(select 字段A from 表一) where 条件=?