>
>If I open the table (edit top 200 rows) its the order I can see the rows in.
>
>
As Sergey said, there's no established row number in a table. You'd had to use the approach that he described (add a column as an identity value).
Alternatively you could add a column and use the ROW_NUMBER() over (order by SpecificColumn) and that will establish a row number as well.