Navigation:  NexusDB Guide > SQL Reference > SQL Language Elements >

Parameters

Previous pageReturn to chapter overviewNext page

NexusDB V3 Manual

Parameters

button_main button_prev button_next

NexusDB Manual V3 > SQL Reference > SQL Language Elements

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

 

© Nexus Database Systems Pty Ltd.

nexus_logo