SQL – SQL Server RAND() Function
The SQL Server RAND() function returns a random number between 0 (inclusive) and 1 (exclusive).
SQL – SQL Server REPLACE() Function
The SQL Server REPLACE() function replaces all occurrences of a substring (case-insensitive) within a string, with a new substring.
SQL – SQL Server REPLICATE() Function
The SQL Server REPLICATE() function repeats a specified string a specified number of times.
SQL – SQL Server REVERSE() Function
The SQL Server REVERSE() function reverses a specified string and returns the result.
SQL – SQL Server RIGHT() Function
The SQL Server RIGHT() function extracts a number of characters (starting from right) from a string.
SQL – SQL Server ROUND() Function
The SQL Server ROUND() function rounds a number to a specified number of decimal places.
SQL – SQL Server RTRIM() Function
The SQL Server RTRIM() function removes trailing spaces from a string. Trailing spaces are spaces after (right of) the string.
SQL – SQL Server SESSION_USER Function
The SQL Server SESSION_USER function returns the name of the current user in the SQL Server database.
SQL – SQL Server SESSIONPROPERTY() Function
The SQL Server SESSIONPROPERTY() function returns the session settings for a specified option.
SQL – SQL Server SOUNDEX() Function
The SQL Server SOUNDEX() function returns a four-character code to evaluate the similarity of two expressions.
SQL – SQL Server SPACE() Function
The SQL Server SPACE() function returns a string of the specified number of space characters.
SQL – SQL Server SQRT() Function
The SQL Server SQRT() function returns the square root of a positive number.
SQL – SQL Server SQUARE() Function
The SQL Server SQUARE() function returns the square of a number (the number times itself).
SQL – SQL Server STUFF() Function
The SQL Server STUFF() function deletes a part of a string, starting at a specified position, and then inserts a new part into the string at that position.
SQL – SQL Server SUBSTRING() Function
The SQL Server SUBSTRING() function extracts a specified number of characters from a specified position in a string.
SQL – SQL Server SUM() Function
The SQL Server SUM() function calculates the sum of a set of values. NULL values are ignored.
SQL – SQL Server SYSDATETIME() Function
The SQL Server SYSDATETIME() function returns the date and time of the computer where the SQL Server is running.