Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Literal of the correct data type required.

You have entered a data type that cannot be converted to a literal of the data type needed for the parameter. This error can occur in the following place:

  • In the value field of Query and View Designer.

SQL objects that contain data have an associated data type that defines the kind of data (character, integer, binary, and so on) the object can contain. When you specify a value, the literal must match the data type defined for the column. For example, you cannot enter an alphabetic string (such as "abc") for a timestamp data type.

For more information on data types, see Data Types (Database Engine).

  1. Change the literal to the correct data type.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft