Owner: | dbo |
Encrypted: | |
Creation Date: | 08/06/2000 |
Description: |
QUOTED_IDENTIFIER: | |
ANSI_NULLS: |
Objects that [dbo].[Ten Most Expensive Products] depends on
Object Name | Owner | Object Type | Dep Level | |
|
Categories | dbo | Table | 1 |
|
Suppliers | dbo | Table | 1 |
|
Products | dbo | Table | 2 |
User/Role | Select | Insert | Delete | Update | Execute | DRI | |
|
public | GRANT |
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
create procedure "Ten Most Expensive Products" AS
SET ROWCOUNT 10
SELECT Products.ProductName AS TenMostExpensiveProducts, Products.UnitPrice
FROM Products
ORDER BY Products.UnitPrice DESC
GO
SET QUOTED_IDENTIFIER OFF
GO
GO
SET ANSI_NULLS OFF
GO
See Also
List of stored procedures