select *from (select row_number() over (order by ousp_id) as rowNum,*
from YZOrder_OutStock_Product
where outs_no=@order_no)) as t
where rowNum = ‘1‘
SQL 循环用while
while 1<100
begin
end
row_number() over (order by ousp_id) 获取行号,布布扣,bubuko.com
row_number() over (order by ousp_id) 获取行号
原文：http://www.cnblogs.com/lengv10/p/3689229.html