DOCUMENTATION CENTER SEARCH
DatabaseLink Paclet SymbolTutorials|See Also|More About

SQLResultSetTake

SQLResultSetTake[rs, {m, n}]
reads rows m through n from a result set.
  • The following option can be given:
"GetAsStrings"Falsereturn the results as strings
EXAMPLESCLOSE ALL
Basic Examples   (1)
Needs["DatabaseLink`"]
If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the DatabaseExamples` package, as described in Using the Example Databases.
In[2]:=
Click for copyable input
Open a result set:
In[3]:=
Click for copyable input
Out[3]=
Get rows 2 through 4:
In[4]:=
Click for copyable input
Out[4]=
Get the last three rows:
In[5]:=
Click for copyable input
Out[5]=
Close the result set:
In[6]:=
Click for copyable input
In[7]:=
Click for copyable input
© 2008 Wolfram Research, Inc. japanese.gif