alter a table column and set identity from max existing in that column in sql server 2008 -


i have column maxcode name, in mytable filled before,now want alter column , set type identity start max number existing in column maxcode

use below code reset seed value identity column

declare @newseed numeric(10) select @newseed = max(maxcode) mytable dbcc checkident (mytable, reseed, @newseed) 

Comments

Popular posts from this blog

Capture and play voice with Asterisk ARI -

java - Why database contraints in HSQLDB are only checked during a commit when using transactions in Hibernate? -

visual studio - Installing Packages through Nuget - "Central Directory corrupt" -