title: Return a single record from a SQL Server Stored Procedure, or use output parameters
body: <p>I am sending an order number, which is unique, to SQL Server from VB.NET by way of a stored procedure. The procedure looks up the corresponding record in the table. I wish to return the values in the selected fields of that record to VB.NET. I can do this using output parameters, which means I have to define them in the procedure and then again in VB, or I can return that single record and put it in a datatable, then extract the values, avoiding the typing. Is there a reason I should stick with output parameters?</p>