SQL Server Advanced Functions
Technology 12 records updated 2026-07-17
SQL Server Advanced Functions, with function, and description.
Get this data
GET https://mysafeinfo.com/api/data/sqlserveradvancedfunctionsSort, page, randomize, and download with query parameters; see the documentation.
Try it live
Run a request against sqlserveradvancedfunctions straight from your browser. Add your API key
to lift the row cap and return every record. The call goes to the API and nothing is stored here.
Preview
First 12 of 12 records. Click a column to sort these rows.
| 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 |
| 11 | SYSTEM_USER | Returns the login name for the current user |
| 12 | USER_NAME | Returns the database user name based on the specified id |
Notes
- Last updated on July 17, 2026.
Related datasets
More in Technology:
- Country Code Top Level Domains — updated July 19, 2026
- CSS Properties — updated July 19, 2026
- File Extensions — updated July 19, 2026
- Git Commands — updated July 19, 2026
- Linux Commands — updated July 19, 2026
- Operating Systems — updated July 19, 2026