求解啊

SQL code

select row_number() over (order by a_stick desc,a_id desc)   as rowid,* from zt_article  

根据a_stick，a_id 排序 增加一自增列

在sql server2000该怎么整啊

[解决办法]
A就是你的表

SQL code

select (select count(*)+1 from  A  where id < t.id) as AutoCode,*    from A t