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.
SQL – SQL Server SYSTEM_USER Function
The SQL Server SYSTEM_USER function returns the login name for the current user.
SQL – SQL Server TRANSLATE() Function
The SQL Server TRANSLATE() function returns the string from the first argument after the characters in the second argument are translated into it.
SQL – SQL Server TRIM() Function
The SQL Server TRIM() function removes leading and trailing spaces (default) OR other specified characters from the start or end of a string.
SQL – SQL Server UNICODE() Function
The SQL Server UNICODE() function returns an integer value (the Unicode value) for the first character of the input expression.
SQL – SQL Server USER_NAME() Function
The SQL Server USER_NAME() function returns the database username based on the specified id.
SQL – SQL Server YEAR() Function
The SQL Server YEAR() function returns the year part for a specified date.
SQL – List of SQL Server Advanced Functions
This is a quick reference list of SQL Server advanced functions and how they are used to work with databases.
SQL – List of SQL Server Date Functions
This is a quick reference list of SQL Server date functions and how they are used to work with databases.
SQL – List of SQL Server Numeric Functions
This is a quick reference list of SQL Server numeric functions and how they are used to work with databases.
SQL – List of SQL Server String Functions
This is a quick reference list of SQL Server string functions and how they are used to work with databases.
SQL – Show all Databases on the Server
This shows all databases on the server, and is handy when looking for a specific database in the system or if you’re acclimating yourself to a new system.