Information générale
Titre:
Viewing SQL server in a grid
I have a basic clarification question. I am using the following commands to view data in our SQL server:
lcsql="SELECT * FROM scEmailView"
lnresult=SQLEXEC(hconn,lcsql,"EmailData2")
The scEmailView is a view created on the server. My question is what happens when the result of the view goes over 2gb in size (other than being really slow)? By using this method am I limiting myself in regards to amount of data displayed? If I wanted to view the tables directly (not the returned cursor) how would I accomplish that?
Just some basic questions I have been asking myself. Thanks in advance for the help.
Kelly
Suivant
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