943,967 Members | Top Members by Rank

Web Development > Databases > MySQL > MS Access v/s MS SQL Server 2000
Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 2218
  • MySQL RSS
Permalink
Nov 12th, 2006
0

MS Access v/s MS SQL Server 2000

Expand Post »
How come MS SQl Server 2000 does not have an autonumber datatype as like MS Access does?

Any alternative?
Similar Threads
Reputation Points: 58
Solved Threads: 1
Posting Whiz in Training
cancer10 is offline Offline
234 posts
since Dec 2004
Permalink
Nov 18th, 2006
0

Re: MS Access v/s MS SQL Server 2000

Click to Expand / Collapse  Quote originally posted by cancer10 ...
How come MS SQl Server 2000 does not have an autonumber datatype as like MS Access does?

Any alternative?
This belongs in the MSSQL forum, but the corresponding datatype is the more powerful identity data type. I don't think it supports 'random' like access, but you can start from any number, and you can set how much the step should be (so it would number 1,3,5,7,9, etc with a step of 2)
MCP
Reputation Points: 14
Solved Threads: 3
Light Poster
MCP is offline Offline
44 posts
since Sep 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: Inserting NULL into database table
Next Thread in MySQL Forum Timeline: MySql/Software Installation-Beginner





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC