Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLExec to return empty record
Message
 
 
To
19/03/2003 09:58:33
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00767402
Message ID:
00767553
Views:
9
>>Try this:
>>
>>SQLExec(lnHandle,'Select Top 0 * from dbo.News')
>>
>
>Now, the question is which one is the fastest. Is it an approach with "Where 1=2" or "Top 0"?

As Mike pointed out in another message, they produce the same execution plan.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform