Query FAQs

Common questions and errors that come up when building Queries and working with Native SQL.

Question	Short answer
Handling a mapper_parsing_exception error	Sanitize Field aliases that contain special characters.
Speeding up MSSQL Queries	Add a connection property to avoid slow parameterized queries.
How Informer handles Native SQL	How Informer prepares, connects, and executes a SQL string.
Datasets vs. Ad hoc Queries	Persisted data versus temporary results, and when to use each.
Hiding vs. unselecting Fields	Hide keeps a Field in the query; unselect removes it.
Are stored procedures supported?	Yes, via EXEC in a Native SQL Query.
text and varchar incompatible error	Convert the deprecated MSSQL TEXT type to VARCHAR.
Why dates display the wrong value	Time zones affect datetime Fields but not date Fields.