Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Results Sets from Stored Procedures
Message
 
 
À
15/05/2007 12:59:42
Moacyr Zalcman
Independent Consultant
São Paulo, Brésil
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
01225649
Message ID:
01225656
Vues:
22
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform