Built-In Functions SQL Server

SQL Server > Built-in Functions

String

• REPLICATE
• ASCII
• LTRIM
• RTRIM
• SUBSTRING
• SOUNDEX
• LEN
• LEFT
• RIGHT
• LOWER
• UPPER
• CHAR
• CHARINDEX
• DIFFERENCE
• FORMAT
• REPLACE
• SUBSTRING
• STUFF
• UNICODE
• PATINDEX
• STR
• SPACE
• CONCAT

Aggregate

• AVG
• MIN
• MAX
• COUNT
• COUNT_BIG
• CHECKSUM_AGG
• STDEV
• GROUPING
• GROUPING_ID
• VAR
• VARP

Conversion

• CAST
• CONVERT
• PARSE
• TRY_CAST
• TRY_CONVERT
• TRY_PARSE

Rank

• RANK & DENSE_RANK
• NTILE
• ROW_NUMBER

Date and Time

• DATEADD
• DATEDIFF
• EOMONTH

System

• ISNUMERIC
• HOST_NAME
• NEWID
• ISNULL
• @@TRANCOUNT
• @@ROWCOUNT

Mathematical

• POWER
• ABS

Metadata

• OBJECT_ID
• APP_NAME