Unsupported or limited syntax options
- Last UpdatedMar 19, 2025
- 1 minute read
The AVEVA Historian OLE DB provider does not support certain syntax options in queries. In general, these limitations are due to underlying limitations in the current Microsoft SQL Server OLE DB Provider implementation.
For general information on creating SQL queries, see your Microsoft SQL Server documentation.
Related Links
- No notion of client context
- Limitations on wide tables
- LIKE clause limitations
- IN clause limitations
- OR clause limitations
- Use joins within an OPENQUERY function
- Use complicated joins
- Use a sub-SELECT with a SQL server table and an extension table
- WHERE clause anomalies
- CONVERT function limitations
- SQL server optimization of complex queries
- Use columns of a variant type with functions
- Using StartDateTime in the query criteria
- Comparison statements and NULL values
- OPENQUERY and microsoft query