Parameter Data Types
Even though each parameter specified with SQLBindParameter is defined using an SQL data type, the parameters in an SQL statement have no intrinsic data type. Therefore, parameter markers can be included in an SQL statement only if their data types can be inferred from another operand in the statement. For example, in an arithmetic expression such as ? + COLUMN1, the data type of the parameter can be inferred from the data type of the named column represented by COLUMN1. An application cannot use a parameter marker if the data type cannot be determined.
The following table describes how a data type is determined for several types of parameters, in accordance with SQL-92. For a more comprehensive specification on inferring the parameter type when other SQL clauses are used, see the SQL-92 specification.
Location of parameter | Assumed data type |
---|---|
One operand of a binary arithmetic or comparison operator | Same as the other operand |
The first operand in a BETWEEN clause | Same as the second operand |
The second or third operand in a BETWEEN clause | Same as the first operand |
An expression used with IN | Same as the first value or the result column of the subquery |
A value used with IN | Same as the expression or the first value if there is a parameter marker in the expression |
A pattern value used with LIKE | VARCHAR |
An update value used with UPDATE | Same as the update column |
Geri Bildirim
https://aka.ms/ContentUserFeedback.
Çok yakında: 2024 boyunca, içerik için geri bildirim mekanizması olarak GitHub Sorunları’nı kullanımdan kaldıracak ve yeni bir geri bildirim sistemiyle değiştireceğiz. Daha fazla bilgi için bkz.Gönderin ve geri bildirimi görüntüleyin