Enum esriSQLFunctionName

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

SQL Functions.

[Guid("18E2854B-EDC8-11D2-AAEF-00C04FA37849")]
public enum esriSQLFunctionName

Fields

esriSQL_ABS = 20

20: SQL ABS.

esriSQL_ACOS = 21

21: SQL ACOS.

esriSQL_ASCII = 15

15: SQL ASCII.

esriSQL_ASIN = 22

22: SQL ASIN.

esriSQL_ATAN = 23

23: SQL ATAN.

esriSQL_AVG = 5

5: SQL AVG.

esriSQL_BITLENGTH = 42

42: SQL BITLENGTH.

esriSQL_CAST = 51

51: SQL CAST.

esriSQL_CEILING = 24

24: SQL CEILING.

esriSQL_CHAR = 16

16: SQL CHAR.

esriSQL_CHARLENGTH = 43

43: SQL CHARLENGTH.

esriSQL_COALESCE = 49

49: SQL COALESCE.

esriSQL_CONCAT = 8

8: SQL CONCAT.

esriSQL_CONVERT = 50

50: SQL CONVERT.

esriSQL_COS = 25

25: SQL COS.

esriSQL_COSH = 38

38: SQL COSH.

esriSQL_COUNT = 3

3: SQL COUNT.

esriSQL_CUME_DIST = 73

73:

esriSQL_CURRENTDATE = 46

46: SQL CURRENTDATE.

esriSQL_CURRENTTIME = 47

47: SQL CURRENTTIME.

esriSQL_CURRENTTIMESTAMP = 52

52: SQL CURRENTTIMESTAMP.

esriSQL_CURRENTUSER = 48

48: SQL CURRENTUSER.

esriSQL_DENSE_RANK = 81

81:

esriSQL_EXTRACT = 41

41: SQL EXTRACT.

esriSQL_FIRST_VALUE = 74

74:

esriSQL_FLOOR = 26

26: SQL FLOOR.

esriSQL_HEX = 40

40: SQL HEX.

esriSQL_LAG = 77

77:

esriSQL_LAST_VALUE = 75

75:

esriSQL_LEAD = 76

76:

esriSQL_LEADING = 9

9: SQL LEADING.

esriSQL_LN = 28

28: SQL LN.

esriSQL_LOG = 27

27: SQL LOG.

esriSQL_LOG10 = 33

33: SQL LOG10.

esriSQL_LOWER = 10

10: SQL LOWER.

esriSQL_MAX = 2

2: SQL MAX.

esriSQL_MIN = 1

1: SQL MIN.

esriSQL_MOD = 29

29: SQL MOD.

esriSQL_NTILE = 80

80:

esriSQL_NULLIF = 53

53: SQL NULLIF.

esriSQL_OCTETLENGTH = 44

44: SQL OCTETLENGTH.

esriSQL_PERCENTILE_CONT = 58

58: SQL Percentile Continuous.

esriSQL_PERCENTILE_DISC = 59

59: SQL Percentile Discrete.

esriSQL_PERCENT_RANK = 78

78:

esriSQL_POSITION = 45

45: SQL POSITION.

esriSQL_POWER = 34

34: SQL POWER.

esriSQL_RANK = 79

79:

esriSQL_REGR_INTERCEPT = 84

84:

esriSQL_REGR_R2 = 85

85:

esriSQL_REGR_SLOPE = 83

83:

esriSQL_ROUND = 35

35: SQL ROUND.

esriSQL_ROW_NUMBER = 82

82:

esriSQL_SIGN = 30

30: SQL SIGN.

esriSQL_SIN = 31

31: SQL SIN.

esriSQL_SINH = 37

37: SQL SINH.

esriSQL_SOUNDEX = 17

17: SQL SOUNDEX.

esriSQL_STDDEV = 7

7: SQL Standard Deviation.

esriSQL_STDDEV_POP = 57

57: SQL STDDEV_POP.

esriSQL_STDDEV_SAMP = 56

56: SQL STDDEV_SAMP.

esriSQL_ST_AREA = 62

62:

esriSQL_ST_LENGTH = 60

60:

esriSQL_ST_MMAX = 72

72:

esriSQL_ST_MMIN = 71

71:

esriSQL_ST_NUMGEOMETRIES = 64

64:

esriSQL_ST_NUMPOINTS = 63

63:

esriSQL_ST_PERIMETER = 61

61:

esriSQL_ST_XMAX = 66

66:

esriSQL_ST_XMIN = 65

65:

esriSQL_ST_YMAX = 68

68:

esriSQL_ST_YMIN = 67

67:

esriSQL_ST_ZMAX = 70

70:

esriSQL_ST_ZMIN = 69

69:

esriSQL_SUBSTRING = 12

12: SQL SUBSTRING.

esriSQL_SUBSTRINGBYTES = 13

13: SQL SUBSTRING Bytes.

esriSQL_SUM = 4

4: SQL SUM.

esriSQL_TAN = 32

32: SQL TAN.

esriSQL_TANH = 39

39: SQL TANH.

esriSQL_TRAILING = 11

11: SQL TRAILING.

esriSQL_TRANSLATE = 18

18: SQL TRANSLATE.

esriSQL_TRIM = 19

19: SQL TRIM.

esriSQL_TRUNCATE = 36

36: SQL TRUNCATE.

esriSQL_UPPER = 14

14: SQL UPPER.

esriSQL_VAR = 6

6: SQL VAR.

esriSQL_VAR_POP = 55

55: SQL VAR_POP.

esriSQL_VAR_SAMP = 54

54: SQL VAR_SAMP.