修改有数据的表sysmenu列为identity属性

SELECT * INTO #TMP_SYSMENU FROM sysmenu;

drop table sysmenu;

CREATE TABLE [dbo].[sysmenu](
 [menuxxid] [int] IDENTITY(1000,1) NOT NULL,
 [suprxxid] [int] NOT NULL,
 [sequence] [int] NOT NULL,
 [menutext] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
 [menuname] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
 [hyperlink] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL,
 [signflag] [char](2) COLLATE Chinese_PRC_CI_AS NOT NULL,
 [pagecntl] [char](1) COLLATE Chinese_PRC_CI_AS NOT NULL,
 [newindow] [char](1) COLLATE Chinese_PRC_CI_AS NULL,
 [SvAddress] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
 [memo] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
 [regidate] [datetime] NULL,
 [regiuser] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
 [modidate] [datetime] NULL,
 [modiuser] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL
);

 

SET IDENTITY_INSERT [dbo].[sysmenu] ON;
INSERT INTO sysmenu(menuxxid,suprxxid, sequence, menutext, menuname, hyperlink, signflag,pagecntl, newindow,SvAddress, memo, regidate,regiuser,modidate, modiuser) SELECT * FROM #TMP_SYSMENU;
SET IDENTITY_INSERT [dbo].[sysmenu] OFF;