Populate SQL table.field with incremental value for unique ID
Posted on 2004-08-19
I have imported a view from an Oracle database via ODBC driver(Executed via scheduled DTS). However, I need to insert a key field so I can create an index, then link it to an MS Access interface. I have added the new field to the imported table (i.e. REPORTS_V_CHK_VW_HOURS). So what I would like to do know is populate the field with an incremental value (i.e. 1, 2, 3, 4, etc.), so each field is uniquely identified.
I am pretty new to MS SQL and eager to learn. Help is very much appreciated.
Thank you in advance