Jan 15 2010

To reset auto increment SQL SERVER

Category: SQLLatif @ 16:52

Hi,

If you want to reset auto increment field, use the code below.

 DBCC CHECKIDENT('TableName', RESEED, 2) ;

See you soon...

 

Tags:

Comments

1.
health news health news Russia says:

{Great news indeed! I just upgraded our company blog and my personal blog to v1.6. I really like the comment management addition. It really makes wading through the comment spam much easier.

3.
stocks stocks United States says:

Have your thought about adding some social bookmark buttons to your site? At least add one for Digg so we can digg you up!

4.
Daniel Millions Daniel Millions United States says:

Do have some sort of email system where your blog posts emailed to me?

5.
debt consolidation loans debt consolidation loans United States says:

I would like to use some of your material for my website. Please let me know if I can do so if I link back to this page.

6.
Tagesgeldkonditionen Tagesgeldkonditionen Germany says:

Advantageously, the post is actually the best on this precious topic. I harmonise with your conclusions and will thirstily look forward to your next updates. I want to say thanks will not just be sufficient, for the tremendous lucidity in your writing style. I will instantly grab your rss feed to stay privy of any updates. Solid work and much success in your business enterprize!

7.
Jeane Felger Jeane Felger United States says:

Hello I am so delighted I found your blog, I really found you by mistake, while I was looking on Yahoo for something else, Anyways I am here now and would just like to say thanks for a tremendous post and a all round entertaining blog (I also love the theme/design), I don’t have time to read it all at the moment but I have bookmarked it and also added your RSS feeds, so when I have time I will be back to read more, Please do keep up the great work.

8.
Modesto Valladolid Modesto Valladolid United States says:

great post, are you a professional writer?

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading