Procedure: Northwind.dbo.[Ten Most Expensive Products]

Collapse All Expand All

Procedure Properties

Name	Value
Owner	dbo
Creation Date	12/13/2004
Type	Standard T-SQL
Encrypted
ID	741577680
Implementation Type	Transact SQL

Creation options

Parameters

Recordsets returned

	Name	DataType	Max Length
	TenMostExpensiveProducts	nvarchar	40
	UnitPrice	money	8

Objects that depend on [Ten Most Expensive Products]

Objects that [Ten Most Expensive Products] depends on

	Object Name	Object Type	Dep Level
	Products	Table	1
	Categories	Table	2
	Suppliers	Table	2

Total 3 object(s)

Column Level Dependencies

	Object Name	Column	Object Type
	Products	ProductName	Table
	Products	UnitPrice	Table

Total 2 column(s)

Graphical Dependencies

Permissions

Extended Properties

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER 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

See also

Buildmasters.com.au