insert a row in .mdf table

V

vineet_link

hi, i wanted to insert a row in a table but when i insert row it
automatically goes to the bottom ( near auto number)
 
R

Rick B

That is correct.

The order in the table is irrelevant. Table data is not stored in any
particular order. You seem to be confusing a database with a spreadsheet.

Your sorting comes into play when you create a query, form, or report. In
those objects you can define which field you'd like to use to sort.

Rick B
 
Top