ACCESS比较用的着的SQL语句

1.在COMPANY表中增加一个自增型字段ID

ALTER TABLE COMPANY ADD COLUMN id AUTOINCREMENT(1,1)

2.修改COMPANY表的A字段为DOUBLE型或CURRENCY型

ALTER TABLE COMPANY ALTER COLUMN A Double

ALTER TABLE COMPANY ALTER COLUMN A Currency

3.在ACCESS查询中申明输入变量

PARAMETERS RQ Short;   //申明一个短整型的变量RQ

SELECT * FROM COMPANY AS WHERE YEAR(CURRYEAR)=RQ