Return parameters  The output keyword

Chapter 16: Using Stored Procedures

Passing values in parameters

To pass values in the parameters, use this format:

@parameter = @variable 

You cannot pass constants; there must be a variable name to “receive” the return value. The parameters can be of any Adaptive Server datatype except text, unitext, or image.

NoteIf the stored procedure requires several parameters, either pass the return value parameter last in the execute statement or pass all subsequent parameters in the form @parameter = value.





Copyright © 2005. Sybase Inc. All rights reserved. The output keyword

View this book as PDF