MySafeInfo

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/sqlserveradvancedfunctions

JSON XML CSV Download CSV

Sort, 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