| Returns data | SQL 2005 Adventure Works OLTP | 
The procedures listed all return data by way of a result set or output parameters.  If the return method includes result sets, at least one result set is listed. 
dbo.uspGetBillOfMaterials
dbo.uspGetEmployeeManagers
dbo.uspGetManagerEmployees
dbo.uspGetWhereUsedProductID