View Single Post
Old 08-19-2004, 07:09 PM   #9 (permalink)
idx
Senior Grasshopper
 
idx's Avatar
 
Join Date: Jun 2003
Location: FL
Posts: 317
idx is on a distinguished road
What about the FETCH FIRST $n ROWS ONLY statement? I remember it being used in the ADODB code.

Looks like OPTIMIZE FOR $n ROWS might also be an option.

-r
idx is offline   Reply With Quote