Kbase P126167: What is a SQL-92 unnamed parameter?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/10/2007 |
|
Status: Unverified
GOAL:
What is a SQL-92 unnamed parameter?
FIX:
A parameterized SQL statement contains parameters, or variables, the values of which can be varied at design time or runtime.
Parameters can replace data values, such as those used in a WHERE clause for comparisons, that appear in an SQL statement.
Ordinarily, parameters stand in for data values passed to the statement.
Unnamed parameters are represented by a question mark (?) in the query
In this SQL statement,(?) are placeholders for actual values supplied to the statement at runtime by an application.
Unnamed parameters are identified by position, because they do not have unique names.
INSERT INTO Country (Name, Capital, Population)
VALUES (?, ?, ?)