遇到的最难的存储过程嵌套游标问题,高手请进!!!
创建一个存储过程 P3，列出Northwind库中的products表中UnitsOnOrder最高的五种商品的相关信息。(用游标做)

[解决办法]
select top 5 UnitsOnOrder, *
from products
order by UnitsOnOrder desc
[解决办法]
--用top 5，如下

select top 5 UnitsOnOrder, *
from products
order by UnitsOnOrder desc


--或者如下：

set rowcount 5

select UnitsOnOrder, *
from products
order by UnitsOnOrder desc
[解决办法]
--能用一条SQL实现的，为什么要用游标，舍近求远？


--用top 5，如下

select top 5 UnitsOnOrder, *
from products
order by UnitsOnOrder desc


--或者如下：

set rowcount 5

select UnitsOnOrder, *
from products
order by UnitsOnOrder desc