>I am using SQL passthtrough to retrieve records via the sqlexec command >is there a way to limit the number of records returned... i.e. the first 5 for example. > >I am only pulling them to view the data to make a decision on whether to pull all of the data... > >User doesn't want to wait for the full table to come across the network... > >Some tables have millions of records! > >Only need a few to help decide if they want all of them... > >Mike
Limit your query to a restricting condition (you always should) and/or use the TOP modifier.
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry