Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Literal of the correct data type required.
Collapse the table of content
Expand the table of content

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.

Community Additions

ADD
Show:
© 2015 Microsoft