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 or image.
If 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.
