Sql Server Lessons -- How To Reseed An Identity Column..

[loveindia]

 

Eyyyyy Dongaa.... 

 

 

evadanna emanna annada... cheppu vesestaaa... 

[Vinuu]

evadanna emanna annada... cheppu vesestaaa... 

  :police:

[Suhaas]

Already unna identity value kanna thakkuva number ki reseed cheyyaniki try chesthe emavthadi.

 

current identity value 1000 undi with 1000 rows id starting from 1 to 1000

 

ippudu identity reseed chesthe 500 ki table ni wat will happen

[loveindia]

Already unna identity value kanna thakkuva number ki reseed cheyyaniki try chesthe emavthadi.

 

current identity value 1000 undi with 1000 rows id starting from 1 to 1000

 

ippudu identity reseed chesthe 500 ki table ni wat will happen

 

if you don't have primary key enabled on that column, no issues you will start getting duplicates..

 

if you have primary key enabled, you will get error... 

[k2s]

[loveindia]

 

what daddy ur kids also studying sql?? 

[ipaddress0]

nuvvu racheheee ;)

[Suhaas]

if you don't have primary key enabled on that column, no issues you will start getting duplicates..

 

if you have primary key enabled, you will get error... 

 

Ok. Thanks bhayya.

[loveindia]

nuvvu racheheee ;)

 

dont tell like that man... vishwamitra doesn't like it man... 

[powerstar02]

:(