Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP-SQL translation
Message
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00749711
Message ID:
00749944
Vues:
34
This message has been marked as a message which has helped to the initial question of the thread.
>Thanks, Sergey. I'm going to use ADO. When I do a seria of selects in SQL Server, should it be written as SP?
>My first select should return matching records ID and the next select will return the actual result. So, where should I put the first select?


First, there's no such word as "seria". <eg>
Second, I would use sproc's regardless if it's one select or T-SQL batch for reasons of performance and security.
Third, the only way to use result of separate query from another is to create a temp. table. It's not recomended for performance reason. Instead you can use result of the first query as derived table in the second query which makes it a one select.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform