SQL Server Advanced Functions
SQL Server advanced functions and descriptions of their uses.
Download optionsThe records
10 of 12 records ยท Select a column heading to sort.
| ID | Function | Description |
|---|---|---|
| 1 | CAST | Converts a value (of any type) into a specified datatype |
| 2 | COALESCE | Returns the first non-null value in a list |
| 3 | CONVERT | Converts a value (of any type) into a specified datatype |
| 4 | CURRENT_USER | Returns the name of the current user in the SQL Server database |
| 5 | IIF | Returns a value if a condition is TRUE, or another value if a condition is FALSE |
| 6 | ISNULL | Return a specified value if the expression is NULL, otherwise return the expression |
| 7 | ISNUMERIC | Tests whether an expression is numeric |
| 8 | NULLIF | Returns NULL if two expressions are equal |
| 9 | SESSION_USER | Returns the name of the current user in the SQL Server database |
| 10 | SESSIONPROPERTY | Returns the session settings for a specified option |
Free sample files (up to 10 rows): CSV JSON XML
Scope and sources
Last checked against sources: October 15, 2026.
Last changed: July 17, 2026. This may reflect a change to the data or its description; it is not a coverage-through date.
A complete download includes all 12 records currently held in this dataset. Check the description and sources to decide whether its scope fits your project.
Use this dataset through the API
GET https://mysafeinfo.com/api/data/sqlserveradvancedfunctionsChoose a format, sort, or request fewer rows. A pass key gives access to the complete dataset. See the examples and parameters.
Without a pass, sorting and randomization apply only to the fixed 10-row sample.