建表时把增长率设为2即可,如
CREATE TABLE jobs
(
job_id smallint
IDENTITY(1,1)
--第一个1中种子,就是从1开始,第二个1是增长率,就每次增长2
PRIMARY KEY CLUSTERED,
job_desc varchar(50) NOT NULL
DEFAULT 'New Position - title not formalized yet',
min_lvl tinyint NOT NULL
CHECK (min_lvl >= 10),
max_lvl tinyint NOT NULL
CHECK (max_lvl <= 250)
)
温馨提示:答案为网友推荐,仅供参考