Enum SqlFunctionType

Namespace

LfrlAnvil.Sql.Expressions.Functions

Assembly

LfrlAnvil.Sql.Core.dll

Represents a type of an SqlFunctionExpressionNode or SqlAggregateFunctionExpressionNode instance.

public enum SqlFunctionType : byte

Fields

Abs = 28

Specifies an SqlAbsFunctionExpressionNode.

Average = 37

Specifies an SqlAverageAggregateFunctionExpressionNode.

ByteLength = 16

Specifies an SqlByteLengthFunctionExpressionNode.

Ceiling = 29

Specifies an SqlCeilingFunctionExpressionNode.

Coalesce = 2

Specifies an SqlCoalesceFunctionExpressionNode.

Count = 39

Specifies an SqlCountAggregateFunctionExpressionNode.

CumulativeDistribution = 44

Specifies an SqlCumulativeDistributionWindowFunctionExpressionNode.

CurrentDate = 3

Specifies an SqlCurrentDateFunctionExpressionNode.

CurrentDateTime = 5

Specifies an SqlCurrentDateTimeFunctionExpressionNode.

CurrentTime = 4

Specifies an SqlCurrentTimeFunctionExpressionNode.

CurrentTimestamp = 7

Specifies an SqlCurrentTimestampFunctionExpressionNode.

CurrentUtcDateTime = 6

Specifies an SqlCurrentUtcDateTimeFunctionExpressionNode.

Custom = 0

Specifies a custom function node.

DenseRank = 43

Specifies an SqlDenseRankWindowFunctionExpressionNode.

ExtractDate = 8

Specifies an SqlExtractDateFunctionExpressionNode.

ExtractDay = 10

Specifies an SqlExtractDayFunctionExpressionNode.

ExtractTemporalUnit = 11

Specifies an SqlExtractTemporalUnitFunctionExpressionNode.

ExtractTimeOfDay = 9

Specifies an SqlExtractTimeOfDayFunctionExpressionNode.

FirstValue = 48

Specifies an SqlFirstValueWindowFunctionExpressionNode.

Floor = 30

Specifies an SqlFloorFunctionExpressionNode.

IndexOf = 25

Specifies an SqlIndexOfFunctionExpressionNode.

Lag = 46

Specifies an SqlLagWindowFunctionExpressionNode.

LastIndexOf = 26

Specifies an SqlLastIndexOfFunctionExpressionNode.

LastValue = 49

Specifies an SqlLastValueWindowFunctionExpressionNode.

Lead = 47

Specifies an SqlLeadWindowFunctionExpressionNode.

Length = 15

Specifies an SqlLengthFunctionExpressionNode.

Max = 36

Specifies an SqlMaxFunctionExpressionNode.

Min = 35

Specifies an SqlMinFunctionExpressionNode.

NTile = 45

Specifies an SqlNTileWindowFunctionExpressionNode.

Named = 1

Specifies an SqlNamedFunctionExpressionNode.

NewGuid = 14

Specifies an SqlNewGuidFunctionExpressionNode.

NthValue = 50

Specifies an SqlNthValueWindowFunctionExpressionNode.

Power = 33

Specifies an SqlPowerFunctionExpressionNode.

Rank = 42

Specifies an SqlRankWindowFunctionExpressionNode.

Replace = 23

Specifies an SqlReplaceFunctionExpressionNode.

Reverse = 24

Specifies an SqlReverseFunctionExpressionNode.

Round = 32

Specifies an SqlRoundFunctionExpressionNode.

RowNumber = 41

Specifies an SqlRowNumberWindowFunctionExpressionNode.

Sign = 27

Specifies an SqlSignFunctionExpressionNode.

SquareRoot = 34

Specifies an SqlSquareRootFunctionExpressionNode.

StringConcat = 40

Specifies an SqlStringConcatAggregateFunctionExpressionNode.

Substring = 22

Specifies an SqlSubstringFunctionExpressionNode.

Sum = 38

Specifies an SqlSumAggregateFunctionExpressionNode.

TemporalAdd = 12

Specifies an SqlTemporalAddFunctionExpressionNode.

TemporalDiff = 13

Specifies an SqlTemporalDiffFunctionExpressionNode.

ToLower = 17

Specifies an SqlToLowerFunctionExpressionNode.

ToUpper = 18

Specifies an SqlToUpperFunctionExpressionNode.

Trim = 21

Specifies an SqlTrimFunctionExpressionNode.

TrimEnd = 20

Specifies an SqlTrimEndFunctionExpressionNode.

TrimStart = 19

Specifies an SqlTrimStartFunctionExpressionNode.

Truncate = 31

Specifies an SqlTruncateFunctionExpressionNode.