SQL Server中的身份值 [英] identity value in sql server

问题描述

嗨
如何更改SQL Server中的现有身份值

我需要一个SQL查询

字段名称:level_2_id
int identity(100,1)主键

我想更改身份(200,1)

Hi
How Can I Change Existing identity value in sql server

i need a sql query for that

field name: level_2_id
int identity(100,1) primary key

i want to change identity(200,1)

推荐答案

看看此 [

Have a look here[^]. It should surely help you out.

This[^] mentions a similar solution as well.

这可能会有所帮助你.
http://www.techrepublic.com/博客/数据中心/how-do-i-reseed-a-sql-server-identity-column/406 [ http://stackoverflow.com/questions/2139735/changing-identity-seed- in-sql-server-permanently [ ^ ]

This might help you.
http://www.techrepublic.com/blog/datacenter/how-do-i-reseed-a-sql-server-identity-column/406[^]
http://stackoverflow.com/questions/2139735/changing-identity-seed-in-sql-server-permanently[^]

这篇关于SQL Server中的身份值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！