select row_number() over (order by Detail_ProductID) as ClnID ,
....
from ...
where ...
用row_number() over (列名) 可以创建自增列
select row_number() over (order by Detail_ProductID) as ClnID ,
....
from ...
where ...
用row_number() over (列名) 可以创建自增列