esriSQLInfo Constants

SQL Syntax Information.

Constant Value Description
esriSQL_​CurrentDateRequiresParentheses 0 SQL CurrentDate Function Requires Parentheses.
esriSQL_​ExtractRequiresCommas 1 SQL Extract Function Requires Commas.
esriSQL_​PositionRequiresCommas 2 SQL Position Function Requires Commas.
esriSQL_​SubstringRequiresCommas 3 SQL Substring Function Requires Commas.
esriSQL_​CorrelationNameAllowsASKeyword 4 Correlation Name Allows AS Keyword.
esriSQL_​NationalStringPrefix 5 The National String Prefix.
esriSQL_​CastAVGParameterToDouble 6 Cast the AVG function parameter to double.
esriSQL_​SupportsInterval 7 Supports INTERVAL
esriSQL_​NeedsDateTimeCast 8 Needs CAST on DATETIME value expression
esriSQL_​NeedsOverForPercentile 9 Needs OVER keyword for PERCENTILE Function

Your browser is no longer supported. Please upgrade your browser for the best experience. See our browser deprecation post for more details.