| String Functions
|
|
|
| Returns the number of times a given input character exists in a given input string. |
|
|
| Returns the number of times a given search string exists in a given input string. |
|
|
| Returns the number of words in a given input string. |
|
|
| Emulates the behavior of Oracle's InitCap string function, which changes the
first letter of each word in uppercase and all others in lowercase. |
|
|
| A string encryption and decryption function that uses a simple algorithm to encrypt and decrypt string values. |
|
|
| Trims the leading zeros of an alphanumeric value. |
|
| Date Functions
|
|
|
| Computes for the age given the birth date and the reference date. |
|
|
| Determines whether the input date is a leap year or not. |
|
|
| Returns the first day of the week for a given date. |
|
|
| Returns the first day of the month for a given date. |
|
|
| Returns the first day of the quarter for a given date. |
|
|
| Returns the last day of the month for a given date. |
|
|
| Returns the input date removing the time portion. |
|
|
| Returns the number of days in a month. |
|
|
| Returns the number of days in a year. |
|
| Tree Functions
|
|
|
| Returns the path of a node from the parent to the current node in a hierarchical/tree-type table. |
|
|
| Returns the level of a given node in a hierarchical/tree-type table. |
|
| Table-Valued Functions
|
|
|
| Returns a table containing integer values from 1 to a maximum value. |
|
|
| Returns a table containing the comma-delimited value parameter as separate records. |
|
| SQL Server Built-in Functions
|
|
|
| SQL Server aggregate functions perform a calculation on a set of values and return a single value. With the exception of the COUNT aggregate function, all other aggregate functions ignore NULL values.
Aggregate functions are frequently used with the GROUP BY clause of the SELECT statement. |
|
|
| SQL Server configuration functions return information about the current configuration option settings. |
|
|
| SQL Server date and time functions are scalar functions that perform an operation on a date and time
input value and returns either a string, numeric, or date and time value. |
|
|
| SQL Server scalar math functions perform a calculation, usually based on input values that are provided as arguments, and return a numeric value. |
|
|
| SQL Server metadata functions return information about the database and database objects. |
|
|
| SQL Server security functions return information about users and roles. Security functions return information that is useful in managing security. |
|
|
| SQL Server string functions are scalar functions that perform an operation on a string input value and return a string or numeric value. |
|
|
| SQL Server system functions perform operations on and return information about values, objects, and settings in SQL Server. |
|