Specify a dynamic value.

 

Syntax

 

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

 

 

Usage

 

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

 

 

Notes

 

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.

 

 

Examples

 

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

 


 

Conformance

 

SQL:2003 standard

 

NexusDB extensions

-

 

-

Core SQL

 

Named dynamic parameters