求解啊解决思路

2012-09-03

求解啊SQL codeselect row_number() over (order by a_stick desc,a_id desc)as rowid,* from zt_article

求解啊

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

asp.net