比如下面的语句
CREATE TABLE jobs
(
job_id smallint
IDENTITY(1,1)
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)
)
中
job_id smallint
IDENTITY(1,1)
PRIMARY KEY CLUSTERED,
指定job_id是标识列,以1为种子,每次递增1sql server的标识用IDENTITY
CREATE TABLE jobs
(
job_id smallint
IDENTITY(1,1)
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)
)
中
job_id smallint
IDENTITY(1,1)
PRIMARY KEY CLUSTERED,
指定job_id是标识列,以1为种子,每次递增1sql server的标识用IDENTITY
即可。
注意:identity(int,1,1)只能用于select into 中。