Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1638
  • Last Modified:

Set an auto-generated unique identifier column in SQL server table.

Having spent years with MS Access I'm now adjusting to SQL Server.

In table design view, how do I create the equivalent of Access's autonumber field?
0
TimHudspith
Asked:
TimHudspith
1 Solution
 
jogosCommented:
You set the identity-property to a int-column, more details
http://msdn.microsoft.com/en-us/library/ms186775(v=sql.105).aspx

In design view that is in the column properties. Look for identity, say it is an identity-column  set startingpoint (seed) of your numbering and the increment
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now