SQL ID自增长

来源:互联网 发布:免费网吧定时软件 编辑:程序博客网 时间:2024/05/29 18:38

方法一:

CREATE TABLE [dbo].[yingTable](    [ID] [bigint] IDENTITY(1,1) NOT NULL,    [Name] [nchar](100) NOT NULL, CONSTRAINT [PK_Base_Dictionary] PRIMARY KEY CLUSTERED (    [ID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GO

方法二:
这里写图片描述

原创粉丝点击