SQL Server and VB/ADO question primary key question..

[BradNeedsYourHelp]

MS Access has an autonumber datatype feature in which columns ( designated as the primary key) automatically get assigned a value (1,2,3 etc..) when a record is inserted into the table.

Does SQL server have the same thing or something similiar?

If not how do you handle primary key columns which will only need a sequential numeric value?

Whats the ADO method for retreving the next number which will be inserted in an autonumber field, when a new row of data is inserted into a table?

I am using VBA in Access 2003 (UI) and Access Project/MSDE 2000 (Database) and ADO not ADO.NET.

[TheMonkey]

SQL Server has an IDENTITY flag you can apply to a column that makes it the same as an AutoNumber.

You retrieve the number AFTER you have done the insert as you cannot guarantee that another transaction has inserted something before you have done anything.

[BradNeedsYourHelp]

excellent. cheers for that.