¥¥¥¥¥¥¥¥¥¥¥¥¥¥关于自增字段¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥
if exists (select * from sysobjects where id = object_id(N'[dbo].[Category]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Category]
GO
CREATE TABLE [dbo].[Category] (
[ID] [int] IDENTITY(1,1) NOT NULL ,
[Name] [nvarchar] (128) NULL ,
[Spec] [nvarchar] (64) NULL ,
[ParentID] [int] NULL ,
[ConsumeCategoryID] [int] NULL ,
[ConsumeID] [int] NULL ,
[Type] [tinyint] NULL ,
[Comment] [nvarchar] (256) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Category] WITH NOCHECK ADD
CONSTRAINT [PK_Category] PRIMARY KEY NONCLUSTERED
(
[ID]
) ON [PRIMARY]
GO
1。如何把自动增字段设置为不自增?
2。如何把一个不自增的字段设置位自增?
比如上面的ID字段