Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Returning a parameter from a stored procedure
Message
 
 
To
09/03/2010 06:34:44
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01453371
Message ID:
01453394
Views:
44
>"...You can have more than one output parameter in a stored procedure"
>
>Therefore, would the stored procedure look something like:
>
>ALTER procedure [dbo].[Candidate_Insert_Blank] (@CreatedByID int, @Return1 int output, @Return2 int output)
>
>Would the output parameters be returned to VFP in their logical order, i.e. Return1 then Return2?
>

Yes but you'll have to pass them by reference.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform