Export (0) Print
Expand All
Expand Minimize

Functions (SQL Server Compact Edition)

Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) supports functions.

SQL Server Compact Edition 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 Edition.

    @@IDENTITY

    COALESCE

    DATALENGTH

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft