Reset of Identity

Question

Post reply

Reset of Identity

vivekjamshedpur

Right there with Babe

Points: 743
More actions
July 15, 2013 at 10:43 pm

#296397

Comments posted to this topic are about the item Reset of Identity
July 16, 2013 at 3:33 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 23 total)

You must be logged in to reply to this topic. Login to reply

Lokesh Vij SSChampion Points: 10836 More actions · Answer 1

Easy one for the day. Thanks Vivek 🙂

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

kapil_kk SSC-Insane Points: 21316 More actions · Answer 2

Good start of the day with the easy one 🙂

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

sathish.venkat666 SSC Journeyman Points: 76 More actions · Answer 3

Ya good start of the day but in this also logic is there it not a very simple it is simple

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 4

Thanks for easy one 🙂

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

paul s-306273 SSChampion Points: 10730 More actions · Answer 5

paul s-306273

SSChampion

Points: 10730

July 16, 2013 at 1:26 am

#1632775

Nice QOTD

DevilsChest Mr or Mrs. 500 Points: 516 More actions · Answer 6

So easy in fact even I did not have to think about it :-P, But there again they are only easy if you already know the answer

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 7

Interesting question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

manik_anu SSCrazy Points: 2377 More actions · Answer 8

nice question... 😀

Manik
You cannot get to the top by sitting on your bottom.

Ellen-477471 SSCrazy Points: 2238 More actions · Answer 9

Just wanted to add the comment for a user that might not know ... if instead of using truncate to clear the table the statement was to "delete" , then the identity count is Not reset.

Thank you for the questions ... it is a great way to learn new things and be reminded of the basics!

Dana Medley SSCertifiable Points: 6764 More actions · Answer 10

Dana Medley

SSCertifiable

Points: 6764

July 16, 2013 at 8:16 am

#1632885

Very good question, thanks!

Everything is awesome!

Revenant SSC-Forever Points: 42467 More actions · Answer 11

Dana Medley (7/16/2013)
Very good question, thanks!

+1 🙂

Tee Time Hall of Fame Points: 3745 More actions · Answer 12

Tee Time

Hall of Fame

Points: 3745

July 16, 2013 at 8:52 am

#1632897

Excellent question!

Narud SSCrazy Points: 2837 More actions · Answer 13

Good but tricky question. Although just was question of pay attention to the fine print, as with legal contracts 😀