使字段自动增加
/*设计使ID自动+1*/
CREATE TABLE [dbo].[vccp_user] (
[ID] [int] identity (1,1) NOT NULL , /*参数1是设置初始值,即第一行的值,2是设置递增量*/
[name] [char] (10) NOT NULL ,
[NatualName] [char] (10) NOT NULL ,
[type] [int] NOT NULL ,
[ower] [char] (10) NOT NULL ,
[locked] [int] NOT NULL ,
[father] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[vccp_user] (
[ID] [int] identity (1,1) NOT NULL , /*参数1是设置初始值,即第一行的值,2是设置递增量*/
[name] [char] (10) NOT NULL ,
[NatualName] [char] (10) NOT NULL ,
[type] [int] NOT NULL ,
[ower] [char] (10) NOT NULL ,
[locked] [int] NOT NULL ,
[father] [int] NULL
) ON [PRIMARY]
GO