SQLSERVER中可以试用IDENTITY类型实现自增长,如:
CREATE TABLE new_employees
(
id_num int IDENTITY(1,1),
fname varchar (20),
minit char(1),
lname varchar(30)
)
CREATE TABLE new_employees
(
id_num int IDENTITY(1,1),
fname varchar (20),
minit char(1),
lname varchar(30)
)
CREATE TABLE [dbo].[tblDocument] (
[id] [bigint] IDENTITY (1, 1) NOT NULL ,
[title] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO方法二:SQLSERVER在建表时,添加字段有选的,在"标识"这一栏里选择"是"就可以了,标志种子 1,标志递增量 1