MSSQL2000移到2005时出现ID不会自动增长出现

最新推荐文章于 2020-07-27 10:47:47 发布

lrxin

最新推荐文章于 2020-07-27 10:47:47 发布

阅读量572

点赞数

分类专栏： MSSQL数据库

MSSQL数据库专栏收录该内容

5 篇文章

订阅专栏

DECLARE @ID INT
SET @ID=0
SELECT @ID=MAX(增长字段名)+1 FROM [表名]
DBCC CHECKIDENT('[dbo].[表名]]', RESEED,@ID)

declare @sql nvarchar(4000)
declare @table nvarchar(400)

declare CustomSend_GetContentLin cursor for select name from sysobjects where xtype='U'and name<>'dtproperties' order by name
open CustomSend_GetContentLin
FETCH NEXT FROM CustomSend_GetContentLin into @table
WHILE @@FETCH_STATUS = 0
BEGIN
set @sql='
DECLARE @ID INT
SET @ID=0
SELECT @ID=MAX(ID)+1 FROM dbo.['+@table+']
DBCC CHECKIDENT(''[dbo].['+@table+']'', RESEED,@ID) '

exec (@sql)
FETCH NEXT FROM CustomSend_GetContentLin into @table
end
CLOSE CustomSend_GetContentLin
DEALLOCATE CustomSend_GetContentLin

--select name from sysobjects where xtype='U'and name<>'dtproperties' order by name