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
esriSQL_​NeedsWithinGroupForPercentile 10 Needs WITHIN GROUP clause for PERCENTILE Function
esriSQL_​CastRequiresCommas 11 SQL CAST Function Requires Commas.
esriSQL_​PositionRequiresArgumentsReversal 12 SQL Position Function Requires Arguments Reversal.

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

You can no longer sign into this site. Go to your ArcGIS portal or the ArcGIS Location Platform dashboard to perform management tasks.

Your ArcGIS portal

Create, manage, and access API keys and OAuth 2.0 developer credentials, hosted layers, and data services.

Your ArcGIS Location Platform dashboard

Manage billing, monitor service usage, and access additional resources.

Learn more about these changes in the What's new in Esri Developers June 2024 blog post.

Close