I'm just learning about stored procedures. If I don't specify output variables, I can still get all of the data. (i.e. in a Gridview control). But do I really need output variables? Can I still access the individual column data without output variables?
Example below (includes one output variable for row count only):
CREATE PROCEDURE [dbo].[spMyStoredProcedure]
@RowCount int output
SELECT * FROM dbTable