How do I create an Auto Increment Column?

Does anyone know how to create a column that will automatically increment
every time new data is added to the field. Similar to MS Access AutoNumber data type or even
like SQL Server IDENTITY property on the column.

I need to create a table that can be used in sqlserver and Oracle 8i that will function similarly from
an application accessing it using ADO. The tables do not have to implement the auto increment the same,
but the application accessing it has to work independantly of the Database.

Thanks,
Rich Received on Thu Jan 06 2000 - 16:37:02 CST