MySQL

MS Access v/s MS SQL Server 2000

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2004

Posts: 234

Reputation: cancer10 is an unknown quantity at this point

Solved Threads: 0

cancer10

Offline

Posting Whiz in Training

MS Access v/s MS SQL Server 2000

Nov 12th, 2006

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

Any alternative?

FocusInterview.com - PHP Interview Questions & Answers

IGCHosting - Cheapest Web Hosting

•

Join Date: Sep 2006

Posts: 44

Reputation: MCP is an unknown quantity at this point

Solved Threads: 3

MCP

Offline

Light Poster

Re: MS Access v/s MS SQL Server 2000

Nov 18th, 2006

•

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)