Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Hector,
I am not using SQL server. It was Oracle in one company and VFP in another company. I have the client side programming same for both. But I got the picture now. Thanks for the response.
Regards
>I assume you are talking to SQL Server. If that is the case I don't think you will see performance decrease as the table grows.
>
>FWIW, here is another way of getting the structure of your table
>
>set fmtonly on
>select * from mytable
>set fmtonly off
>
>I don't know if this will increase/decrease performance. But if you open a view with NODATA this is what VFP send to SQL Server.
>
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement