本文介绍了SQL语句中参数的合法使用位置，如INSERT语句的VALUES列表和WHERE子句的比较值。强调参数不应用于标识符如表或列名，也不用于二元操作符的两边，因为这会导致无法确定参数类型。通常，参数只限于DML语句，不适用于DDL语句。
Note:
The markers are legal only in certain places in SQL statements.
For example, they are allowed in the VALUES() list of an INSERT statement
(to specify column values for a row), or in a comparison with a column in
a WHERE clause to specify a comparison value.
However, they are not allowed for identifiers (such as table or column names),
in the select list that names the columns to be returned by a SELECT statement),
or to specify both operands of a binary operator such as the =
equal sign. The latter restriction is necessary because it would be impossible
to determine the parameter type. In general, parameters are legal only in Data
Manipulation Languange (DML) statements, and not in Data Defination Language
(DDL) statements.
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
