General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Will this query take long time using SPT?
Hi All,
Can someone please tell me whether the following query (using SQL pass-through) would take long time if the table grows into millions?
=SQLExec(nMyHandle, "SELECT * FROM mytable WHERE 1=2", "mycursor")
Actually what I want was the exact structure of back-end table and that is why I put a false WHERE clause.
Or is there another way to get the table structure into array or cursor?
Thanks for your time.
Regards
Vijay
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only