SQLProvider

CanonicalOp Type

Union cases

Union case Description

ACos

Full Usage: ACos

ASin

Full Usage: ASin

ATan

Full Usage: ATan

Abs

Full Usage: Abs

AddDays SqlItemOrColumn

Full Usage: AddDays SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn

AddHours float

Full Usage: AddHours float

Parameters:
    Item : float

Item : float

AddMinutes SqlItemOrColumn

Full Usage: AddMinutes SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn

AddMonths int

Full Usage: AddMonths int

Parameters:
    Item : int

Item : int

AddSeconds float

Full Usage: AddSeconds float

Parameters:
    Item : float

Item : float

AddYears SqlItemOrColumn

Full Usage: AddYears SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn

BasicMath(string, obj)

Full Usage: BasicMath(string, obj)

Parameters:
    Item1 : string
    Item2 : obj

Item1 : string
Item2 : obj

BasicMathLeft(string, obj)

Full Usage: BasicMathLeft(string, obj)

Parameters:
    Item1 : string
    Item2 : obj

Item1 : string
Item2 : obj

BasicMathOfColumns(string, string, SqlColumnType)

Full Usage: BasicMathOfColumns(string, string, SqlColumnType)

Parameters:
Item1 : string
Item2 : string
Item3 : SqlColumnType

CaseNotSql(Condition, SqlItemOrColumn)

Full Usage: CaseNotSql(Condition, SqlItemOrColumn)

Parameters:
Item1 : Condition
Item2 : SqlItemOrColumn

CaseSql(Condition, SqlItemOrColumn)

Full Usage: CaseSql(Condition, SqlItemOrColumn)

Parameters:
Item1 : Condition
Item2 : SqlItemOrColumn

CaseSqlPlain(Condition, obj, obj)

Full Usage: CaseSqlPlain(Condition, obj, obj)

Parameters:
Item1 : Condition
Item2 : obj
Item3 : obj

CastInt

Full Usage: CastInt

CastVarchar

Full Usage: CastVarchar

Ceil

Full Usage: Ceil

Cos

Full Usage: Cos

Date

Full Usage: Date

DateDiffDays SqlItemOrColumn

Full Usage: DateDiffDays SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn

DateDiffSecs SqlItemOrColumn

Full Usage: DateDiffSecs SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn

Day

Full Usage: Day

Floor

Full Usage: Floor

Greatest SqlItemOrColumn

Full Usage: Greatest SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn

Hour

Full Usage: Hour

IndexOf SqlItemOrColumn

Full Usage: IndexOf SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn
Item1 : SqlItemOrColumn
Item2 : SqlItemOrColumn

Least SqlItemOrColumn

Full Usage: Least SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn

Length

Full Usage: Length

Minute

Full Usage: Minute

Month

Full Usage: Month

Pow SqlItemOrColumn

Full Usage: Pow SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn

PowConst SqlItemOrColumn

Full Usage: PowConst SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn
Item1 : SqlItemOrColumn
Item2 : SqlItemOrColumn

Round

Full Usage: Round

RoundDecimals int

Full Usage: RoundDecimals int

Parameters:
    Item : int

Item : int

Second

Full Usage: Second

Sin

Full Usage: Sin

Sqrt

Full Usage: Sqrt

Substring SqlItemOrColumn

Full Usage: Substring SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn
Item1 : SqlItemOrColumn
Item2 : SqlItemOrColumn

Tan

Full Usage: Tan

ToLower

Full Usage: ToLower

ToUpper

Full Usage: ToUpper

Trim

Full Usage: Trim

Truncate

Full Usage: Truncate

Year

Full Usage: Year

Type something to start searching.