Export (0) Print
Expand All
Expand Minimize

Functions (SQL Server Compact)

Microsoft SQL Server Compact supports functions.

SQL Server Compact supports the following functions.

  • Aggregate Functions

    Perform calculations on a set of values and return a single value. Except for the COUNT function, aggregate functions ignore null values.

    AVGAVG

    COUNT

    MAX

    MIN

    SUM

  • Date and Time Functions

    Perform an operation on a date and time input value and return a string, numeric, or date and time value.

    DATEADD

    DATEDIFF

    DATENAME

    DATEPART

    GETDATE

  • Mathematical Functions

    Perform calculations based on input values provided as parameters to the function and return a numeric value.

    ABS

    ACOS

    ASIN

    ATAN

    ATN2

    CEILING

    COS

    COT

    DEGREES

    EXP

    FLOOR

    LOG

    LOG10

    PI

    POWER

    RADIANS

    RAND

    ROUND

    SIGN

    SIN

    SQRT

    TAN

  • String Functions

    Perform an operation on a string input value and return a string or numeric value.

    NCHAR

    CHARINDEX

    LEN

    LOWER

    LTRIM_lce_ltrim

    PATINDEX

    REPLACE

    REPLICATE

    RTRIM

    SPACE_lce_space

    STR

    STUFF

    SUBSTRING

    UNICODE

    UPPER_lce_upper

  • System Functions

    Perform operations on, and return information about, values, objects, and settings in SQL Server Compact.

    @@IDENTITY

    COALESCE

    DATALENGTH

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft