Functions

Functions

SQL Server 2000

Microsoft® SQL Server™ 2000 Windows® CE Edition (SQL Server CE) supports the following functions.

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

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

PATINDEX

REPLACE

REPLICATE

RTRIM

SPACE

STR

STUFF

SUBSTRING

UNICODE

UPPER

System Functions Perform operations on, and return information about values, objects, and settings in SQL Server CE.
@@IDENTITY

CASE

COALESCE

CONVERT

DATALENGTH

NEWID

Show:
© 2016 Microsoft