批次目標 | SQL Server | MS Access |
---|---|---|
新增 |
insert into tb1(序號, 姓名) select 1,'章大千' union all select 2,'小填填' union all select 3,'娃哈哈' |
|
更新 |
update tb1 set tb1.姓名=(select tbBuffer.姓名 from tbBuffer where tbBuffer.序號=tb1.序號) where tb1.序號 in (select tbBuffer.序號 from tbBuffer) |
|