Eurodata Computing Logo Technical Tips



Tip : 8
Technology : SQL Server
Title : Information Returned by Stored Procedures.
Stored Procedures can return information in three different ways.

• One or more values can be returned using the stored procedure’s parameters, as long as the ‘OUTPUT’ keyword is used after each parameter declaration. This is similar in concept to passing by reference in VB or by pointer in C.

• All stored procedures can return a single integer value using the ‘RETURN’ statement, this is commonly used to return error codes, or perhaps an identity value allocated during an insert statement.

• The stored procedure can return one or more resultsets.

Need further technical assistance ? Click here for more technical information.

Tech Tip Index

This article is provided 'as is' and no responsibility can be accepted for any errors. No part of this article may be used or reproduced in any fashion without the prior consent of Eurodata Computing Ltd. For syndication enquiries please contact us.
Site designed and maintained by Eurodata Computing
© Eurodata Computing 2000-13    Last updated : April 2013
Valid XHTML 1.0 Transitional Valid CSS!