Specify a dynamic value.


<dynamic parameter specification> ::= :parameter-name | ?


Parameters are used to specify dynamic values that are passed to the statement by the client application.


The parameter-name can be any name you choose, but a common (and good) practice is to use descriptive names.
The notation of using a question mark to represent parameters is only used with ODBC and ADO.NET data access.

Tip: Preparing statements with parameters will improve the efficiency when the same statement is executed more than once.


SELECT statement with parameters in the search condition

INSERT statement with parameters in the VALUES clause

UPDATE statement with parameters in the SET clause

DELETE statement with parameters in the WHERE clause


SQL:2003 standard

NexusDB extensions



Core SQL

Named dynamic parameters

Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Language Elements