Parameters

Wed, 03/04/2009 - 20:02 |  hdanzl

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
‹ Boolean LiteralsupSQL Data Types ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Language Elements

Powered by Drupal and Drupal Theme created with Artisteer.