Access自动编号复位
ALTER TABLE Admin alter COLUMN [ID] COUNTER (1, 1)
将一个表的数据复制到另一个表
insert into newtablename select * from tablename
insert 新表(column1,column2.......)
select column1,column2..
from 旧表
update的两种用法
update table2 set adr = (Select top 1 address from table1 where table1.id = table2.id)
update table2,table1 set table2.adr = table1.address where table1.id = table2.id
[ 查看全文 ]