Syntax error in query. Parameter value. (Error 3746)

This error can occur when:

  • An invalid parameter data type is being used with parameterized queries/procedures.
  • A procedure and the named parameter are not preceded by the @ symbol.
  • An invalid parameter name is passed after the @ symbol.
  • There is not an equal (=) sign after a parameter.
  • Reserved words are used as parameters without the proper escape characters.

Community Additions