sqlways:sql-server:functions

SQL Server Functions

SQL Functions Mapping to Other Databases
Numeric Functions
- ABS
- ACOS
- ASIN
- ATAN
- ATN2
- CEILING
- COS
- COT
- DEGREES
- EXP
- FLOOR
- LOG
- LOG10
- PI
- POWER
- RADIANS
- RAND
- ROUND
- SIGN
- SIN
- SQRT
- SQUARE
- TAN
String Functions
- ASCII
- CHAR
- CHARINDEX
- DIFFERENCE
- LEFT
- LEN
- LOWER
- LTRIM
- NCHAR
- PATINDEX
- QUOTENAME
- REPLACE
- REPLICATE
- REVERSE
- RIGHT
- RTRIM
- SOUNDEX
- SPACE
- STUFF
- SUBSTRING
- UNICODE
- UPPER
Date and Time Functions
- CURRENT_TIMESTAMP
- DATEADD
- DATEDIFF
- DATENAME
- DATEPART
- DAY
- GETDATE
- GETUTCDATE
- ISDATE
- MONTH
- SET DATEFIRST
- SET DATEFORMAT
- SET LANGUAGE
- sp_helplanguage
- SWITCHOFFSET
- SYSDATETIME
- SYSDATETIMEOFFSET
- SYSUTCDATETIME
- TODATETIMEOFFSET
- YEAR
Analitic and Aggregate Functions
- AVG
- CHECKSUM_AGG
- COUNT
- COUNT_BIG
- DENSE_RANK
- GROUPING
- MAX
- MIN
- NTILE
- RANK
- ROW_NUMBER
- STDEV
- STDEVP
- SUM
- VAR
- VARP
Conversion Functions
- CAST
- CONVERT
- STR
XML Functions
- OPENXML
Environment and System Functions
Other Functions