row_number() over (order by ousp_id) 获取行号

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