PROCEDURE Clause Example

This example names the query CategoryList.

PROCEDURE CategoryList; 
SELECT DISTINCTROW CategoryName, CategoryID 
FROM Categories 
ORDER BY CategoryName;