Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Results Sets from Stored Procedures
Message
 
 
To
15/05/2007 12:59:42
Moacyr Zalcman
Independent Consultant
São Paulo, Brazil
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
01225649
Message ID:
01225656
Views:
21
Can you be nmore specific on how do you want to work with data inside sproc?

>When I call a stored procedure from Visual FoxPro it returns every result set to the client
>CREATE PROCEDURE dbo.Teste
>AS
>BEGIN
>   select * from agenda
>   select * from pais
>   select getdate()
>  RETURN 1
>END
>It returns 3 result sets to the client. Is there a way to avoid this? I want to do the queries
>I want to work with the data inside the procedure but I don't want the result sets back.
>
>TIA
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform