Archita's Blog

Thursday, 14 March 2013

SQL -Tip

The following line resets the Identity value for the Customer table to 0 so that the next record added starts at 1.

DBCC CHECKIDENT('Customer', RESEED, 0)
Posted by Unknown at 21:52
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: SQL Server

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Topics

  • .NET
  • Cloud
  • Design patterns
  • Design principles
  • MEF
  • PRISM
  • SQL
  • Thoughts
  • WCF
  • WPF
  • Windows 8
  • Windows Azure
Powered By Blogger

Blogadda

Visit BlogAdda.com to discover Indian blogs

Popular Posts

  • Continuous Integration
  • What is HTML 5 - 1
  • SQL Server 2005 : spt_values table

Blog Archive

  • ►  2014 (2)
    • ►  June (2)
  • ▼  2013 (35)
    • ▼  March (6)
      • ASP.NET - A simple Question
      • Search string in CSV
      • Getting Exception 1
      • Continuous Integration
      • SQL -Tip
      • OAuth - An Overview
    • ►  February (7)
    • ►  January (22)
  • ►  2012 (127)
    • ►  December (15)
    • ►  November (6)
    • ►  October (7)
    • ►  September (14)
    • ►  August (33)
    • ►  July (44)
    • ►  June (8)
  • ►  2009 (1)
    • ►  July (1)
  • ►  2008 (5)
    • ►  October (3)
    • ►  September (1)
    • ►  February (1)
  • ►  2007 (1)
    • ►  April (1)

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

About Me

  • Unknown
  • Unknown
Simple theme. Powered by Blogger.