how to update table after query

[nibabug]

i write like this: SELECT * FROM TB_ANGEL ORDER BY angel ASC but i want not only query by order, i also want update the table by order thanks a lot:)

wuhuaiji

[John ph]

Records in the table are physically sorted in the order of the Primary key Column by default. You can't update the order of the records programmatically.

Regards
 - J O N -

---

[Mike Dimmick]

Actually they are physically sorted in the order of the clustered index information - that's what 'clustered index' means. However, it is the default to build the index supporting the primary key as the clustered index. Tables without a clustered index are not sorted and are referred to as 'heaps'. Specific rows in a heap are referred to internally using row identifiers which give the physical location of the row, but this information isn't available to clients. If you wish to update a specific row, you need to include some kind of row identifier within the table such that each row has its own identifier. SQL Server 2005 does provide the RANK function which might prove helpful for updating an ad-hoc query.

---

DoEvents: Generating unexpected recursion since 1991

[nibabug]

thanks a lot:)

wuhuaiji