SQL – SQL Server CHAR() Function
The SQL Server CHAR() function returns the character based on the ASCII code specified.
SQL – SQL Server CHARINDEX() Function
The SQL Server CHARINDEX() function searches for a substring in a string, and returns the position. If the substring is not found, this function returns 0.
SQL – SQL Server COALESCE() Function
The SQL Server COALESCE() function returns the first non-null value in a list.
SQL – SQL Server CONCAT() Function
The SQL Server CONCAT() function adds two or more strings together.
SQL – SQL Server Concat With +
The SQL Server + operator allows you to add two or more strings together.
SQL – SQL Server CONVERT() Function
The SQL Server CONVERT() function converts a value of any type into a specified datatype.
SQL – SQL Server CONCAT_WS() Function
The SQL Server CONCAT_WS() function adds two or more strings together with a separator.
SQL – SQL Server COUNT() Function
The SQL Server COUNT() function returns the number of records returned by a select query. NULL values are not counted.
SQL – SQL Server CURRENT_TIMESTAMP Function
The SQL Server CURRENT_TIMESTAMP() function returns the current date and time as “YYYY-MM-DD HH-MM-SS”.
SQL – SQL Server CURRENT_USER Function
The SQL Server CURRENT_USER function returns the name of the current user in the SQL Server database.
SQL – SQL Server DATALENGTH() Function
The SQL Server DATALENGTH() function returns the number of bytes used to represent an expression.
SQL – SQL Server DATEADD() Function
The SQL Server DATEADD() function adds a time/date interval to a date and then returns the date.
SQL – SQL Server DATEDIFF() Function
The SQL Server DATEDIFF() function returns the difference between two dates.
SQL – SQL Server DATEFROMPARTS() Function
The SQL Server DATEFROMPARTS() function returns a date from the specified parts (year, month, and day values).
SQL – SQL Server DATENAME() Function
The SQL Server DATENAME() function returns a specified part of a date as a string value.
SQL – SQL Server DATEPART() Function
The SQL Server DATEPART() function returns a specified part of a date as an integer value.
SQL – SQL Server DAY() Function
The SQL Server DAY() function returns the day of the month (from 1 to 31) for a specified date.
SQL – SQL Server DEGREES() Function
The SQL Server DEGREES() function converts a value in radians to degrees.