WOLFRAM

Wolfram Language & System Documentation Center

SQLArgument[arg1,arg2,…]

holds a sequence of arguments to an SQL query.

Details and Options
Details and Options Details and Options
Examples  
Basic Examples  
See Also
Tech Notes
Related Guides
DatabaseLink`
DatabaseLink`

SQLArgument

SQLArgument[arg1,arg2,…]

holds a sequence of arguments to an SQL query.

Details and Options

Examples

Basic Examples  (1)

Wolfram Language code: 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 "DatabaseLink`DatabaseExamples`" package, as described in Using the Example Databases.

Open a connection:

Wolfram Language code: conn = OpenSQLConnection["demo"];

Select multiple columns:

Wolfram Language code: SQLExecute[conn, "SELECT NAME, VALUE FROM SAMPLETABLE1"]

Use a prepared statement to execute the same query:

Wolfram Language code: SQLExecute[conn, "SELECT `1` FROM `2`", {SQLArgument[SQLColumn["NAME"], SQLColumn["VALUE"]], SQLTable["SAMPLETABLE1"]}]

Use a prepared statement to insert data:

Wolfram Language code: SQLCreateTable[conn, SQLTable["TEST"], {SQLColumn["A", "DataTypeName" -> "Integer"], SQLColumn["B", "DataTypeName" -> "Integer"]}];
Wolfram Language code: SQLExecute[conn, "INSERT INTO TEST (A, B) VALUES (`1`)", {SQLArgument[3, 7]}];
Wolfram Language code: SQLSelect[conn, "TEST"]
Wolfram Language code: SQLDropTable[conn, "TEST"];
Wolfram Language code: CloseSQLConnection[conn];