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 MySQL Advanced Functions
This is a quick reference list of MySQL advanced functions and how they are used to work with databases.
SQL – List of MySQL Date Functions
This is a quick reference list of MySQL date functions and how they are used to work with databases.
SQL – List of MySQL Numeric Functions
This is a quick reference list of MySQL numeric functions and how they are used to work with databases.
SQL – List of MySQL String Functions
This is a quick reference list of MySQL string functions and how they are used to work with databases.
SQL – List of SQL Keywords
This is a quick reference list of SQL keywords and how they are used to write SQL statements.
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 – Quick Reference
This is a quick reference list of SQL statements and what they do within the database.
Python – Dictionary clear() Method
The Python dictionary clear() method removes all the elements from a dictionary.
Python – Dictionary copy() Method
The Python dictionary copy() method returns a copy of the specified dictionary.