i have column name id in which in inserted 1640 values manually..
now i have requirement from client..column id values should be automatically inserted startinhg from 1641..
is it possible to alter table and insert identity to existing column ID OR
shall i try QUERY BELOW:
DBCC CHECKIDENT('PRICES',RESEED,1640)