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

[loveindia]

Hi guys,

 

We know in SQL Server we auto increment numbers using an identity on the column... what if , you want to reset the incrementing number or increase it to a different number or start from a different number... Read this article I wrote on How to reseed or reset an identity column in sql server which gives you pretty much all the understanding you need to master the DBCC commands... Most of this piece is never covered in any trainings...

 

http://sqlsaga.com/sql-server/how-to-reseed-reset-an-identity-column-in-sql-server/

 

If you like the article, like SqlSaga on facebook and help us reach more people..

 

Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.

 

Leave your feedback by writing comments. If you have any questions or request an article, use our Facebook Fan page / leave a comment under the comment section / write to us using the contact us page..

 

Good Luck Studying... 

[loveindia]

[Vinuu]

 GP

[loveindia]

 GP

 

neekenti??? 

[barney]

gp

[Vinuu]

neekenti??? 

training classes epudu start for next batch....:)

[loveindia]

training classes epudu start for next batch.... :)

 

chestaanu inko 1 1/2 weeks lopu... ...

[Vinuu]

chestaanu inko 1 1/2 weeks lopu... ...

:) :)

[loveindia]

:) :)

 

neeku special classes kaavalantey provide chestaanu Vinuu... 

[Vinuu]

neeku special classes kaavalantey provide chestaanu Vinuu... 

:police:  %<>(

[loveindia]

:police:  %<>(

 

Eyyyyy Dongaa.... 

[loveindia]

gp

 

Thanks Man... Study well and settle well man... 

[kum5758]

GP Bhayya.

[loveindia]

GP Bhayya.

 

I will be more glad if you study and make use of it man... 

[Vinuu]

Eyyyyy Dongaa....