今天在看
Java5+Eclipse视窗应用程式开发－实作进销存系统(附CD)
看到第十二章在建构MENUREGIST的资料表时，有一个栏位UNIQUEKEY要设成int IDENTITY，糟糕我在SQL 2008 expree里不会设，只好设成int，后来才了解这跟MySQL的auto_increment是一样的功能，我try了好几次的alter table MENUREGIST alter column UNIQUEKEY IDENTITY(1,1) …之类的好几种不同变更IDENTITY的可能语法，结果都错了，只好放弃了，重建吧，还好资料还没进去！
语法如下：
CREATE TABLE [dbo].[MENUREGIST](
[MENUNAME] [varchar](12) NOT NULL,
[MENUDESC] [varchar](36) NOT NULL,
[APPLDESC] [varchar](60) NOT NULL,
[MENUORFUNC] [varchar](2) NOT NULL,
[STARTUSE] [varchar](1) NOT NULL,
[DESCMARK] [varchar](60) NULL,
[UNIQUEKEY] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PK_MENUREGIST] PRIMARY KEY CLUSTERED
(
[UNIQUEKEY] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]