This example names the query CategoryList.
PROCEDURE CategoryList; SELECT DISTINCTROW CategoryName, CategoryID FROM Categories ORDER BY CategoryName;