ms-sql修改自增量起始值
2011-10-10 13:47 Lecone.JY.HU 阅读(349) 评论(0) 编辑 收藏 举报ms-sql修改自增量起始值
SET IDENTITY_INSERT [tableName] ON
DBCC CHECKIDENT ([tableName] ,RESEED,200)
SET IDENTITY_INSERT [tableName] Off
DBCC CHECKIDENT ([tableName] ,RESEED,200)
SET IDENTITY_INSERT [tableName] Off
200指的是起始值。下个值就会从201开始。