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
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
转载于:https://www.cnblogs.com/lengv10/p/3689229.html