Northwind
Basic Index
Expanded Index
Stored Procedure:
Ten Most Expensive Products
There are no parameters
create procedure "Ten Most Expensive Products" AS
SET ROWCOUNT 10
SELECT Products.ProductName AS TenMostExpensiveProducts, Products.UnitPrice
FROM Products
ORDER BY Products.UnitPrice DESC