For easy reference, we have provided a list of all SQL Server (Transact-SQL) functions. The list of SQL Server functions is sorted alphabetically based on the function name.
These functions can be used in SQL statements or queries in SQL Server. Or, they can be used within the programming environment provided by the SQL Server (Transact-SQL) database, such as stored procedures, functions, triggers, etc.
Below is the list of SQL Server (Transact-SQL) functions, sorted by alphabetically by function name.
These functions can be used in SQL statements or queries in SQL Server. Or, they can be used within the programming environment provided by the SQL Server (Transact-SQL) database, such as stored procedures, functions, triggers, etc.
Below is the list of SQL Server (Transact-SQL) functions, sorted by alphabetically by function name.
- ABS
- ASCII
- AVG
- CASE
- CAST
- CEILING
- CHAR
- CHARINDEX
- COALESCE
- CONCAT
- Concat with +
- CONVERT
- COUNT
- CURRENT_TIMESTAMP
- CURRENT_USER
- DATALENGTH
- DATEADD
- DATEDIFF
- DATENAME
- DATEPART
- DAY
- FLOOR
- GETDATE
- GETUTCDATE
- ISDATE
- ISNULL
- ISNUMERIC
- LAG
- LEAD
- LEFT
- LEN
- LOWER
- LTRIM
- MAX
- MIN
- MONTH
- NCHAR
- NULLIF
- PATINDEX
- RAND
- REPLACE
- RIGHT
- ROUND
- RTRIM
- SESSION_USER
- SESSIONPROPERTY
- SIGN
- SPACE
- STR
- STUFF
- SUBSTRING
- SUM
- SYSTEM_USER
- UPPER
- USER_NAME
- YEAR
No comments:
Post a Comment