i have a large access table . i need to have a column which will have value as row number how can i write an sql query fill an empty column inserted by me with row numbers
A:
Im sorry, im a little confused at what you're getting at, but could you not just do an alter table?
ALTER TABLE my_table
ADD row_number int;
cdnicoll
2010-03-02 07:55:19
the value of fields should be equal to corresponding row number not blank
silverkid
2010-03-02 08:06:07
An Autonumber field will be populated when it's created. However, the resulting ordering may not be exactly what you expect.
David-W-Fenton
2010-03-03 02:38:19
A:
Make the Field DataType AutoNumber it will do it for you automatically.
Wael Dalloul
2010-03-02 07:57:16
no once the data is entered in the table the new field cant be set to autoincrement ..
silverkid
2010-03-02 07:59:59
A:
Write a sequence for your table . Then have default value as sequence .
So, whenever the column does not get users values , it will take the sequence values.
pavun_cool
2010-03-02 08:00:01