Update SQLServer Identity Column


DECLARE @NewId INT = 23

DECLARE @TableName VARCHAR(MAX'Database.Schema.TableName'

DBCC CHECKIDENT (@TableName, RESEED@NewId)