Enum esriSQLInfo

Namespace
ESRI.ArcGIS.Geodatabase
Assembly
ESRI.Server.Geodatabase.dll

SQL Syntax Information.

[Guid("CD4BE97F-3E75-4E47-AD67-CFD36DFC1832")]
public enum esriSQLInfo

Fields

esriSQL_CastAVGParameterToDouble = 6

6: Cast the AVG function parameter to double.

esriSQL_CastRequiresCommas = 11

11: SQL CAST Function Requires Commas.

esriSQL_CorrelationNameAllowsASKeyword = 4

4: Correlation Name Allows AS Keyword.

esriSQL_CurrentDateRequiresParentheses = 0

0: SQL CurrentDate Function Requires Parentheses.

esriSQL_ExtractRequiresCommas = 1

1: SQL Extract Function Requires Commas.

esriSQL_Log10RequiresTwoArguments = 15

15: SQL LOG10 function requires two arguments.

esriSQL_ModRequiresOperator = 14

14: Requires to use Modulo operator for MOD SQL Function.

esriSQL_NationalStringPrefix = 5

5: The National String Prefix.

esriSQL_NeedsDateTimeCast = 8

8: Needs CAST on DATETIME value expression

esriSQL_NeedsOverForPercentile = 9

9: Needs OVER keyword for PERCENTILE Function

esriSQL_NeedsWithinGroupForPercentile = 10

10: Needs WITHIN GROUP clause for PERCENTILE Function

esriSQL_PositionRequiresArgumentsReversal = 12

12: SQL Position Function Requires Arguments Reversal.

esriSQL_PositionRequiresCommas = 2

2: SQL Position Function Requires Commas.

esriSQL_RequiresInterval = 13

13: Requires to use Interval instead of Numeric Value with DATETIME arithmetic Expression.

esriSQL_SubstringRequiresCommas = 3

3: SQL Substring Function Requires Commas.

esriSQL_SupportsInterval = 7

7: Supports INTERVAL

esriSQL_TruncateRequiresThreeArguments = 16

16: SQL TRUNCATE Function requires three arguments.