 |
Technical Tips |
 |
 |
|
|
Software
Links
|
||
 |
 |
|
||||||
|
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 |
|