This is documentation for Mathematica 6, which was
based on an earlier version of the Wolfram Language.
View current documentation (Version 11.1)

SQLResultSetOpen

SQLResultSetOpen[query]
makes a result set from an SQL query.
  • To use SQLResultSetOpen, you first need to load DatabaseLink using Needs["DatabaseLink`"].
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
In[3]:=
Click for copyable input
Out[3]=
In[4]:=
Click for copyable input
In[5]:=
Click for copyable input
 
Needs["DatabaseLink`"]
Use SQLSelect instead of SQLExecute:
In[2]:=
Click for copyable input
In[3]:=
Click for copyable input
Out[3]=
In[4]:=
Click for copyable input
In[5]:=
Click for copyable input