Category Archives: SQL Function

SQL NOW() and SQL-Server GETDATE() Function

SQL NOW() - The function NOW() is returns current system date and time. The GETDATE() function used to get current date time in SQL Server.

SQL ROUND() Function

SQL ROUND() - The ROUND() function used to rounds the value and returns it.

SQL LEN() Function

SQL LEN() - The LEN() function used to returns the length of text field. The LEN() function is sql scalar function.

SQL MID() and SQL-Server SUBSTRING() FUNCTION

SQL MID() - The MID() function is used to return exact text from given text field. The SUBSTRING() function used in sql server for same use of MID().

SQL LCASE() and SQL-Server LOWER() Function Example

SQL LCASE() - The SQL LCASE() function used to convert text to lowercase and return it. SQL Server LOWER() - The SQL Server LOWER() function used to convert text to lowercase and return it.

SQL UCASE() and SQL-Server UPPER() Function Example

SQL UCASE() - The SQL UCASE() function used to convert text to uppercase and return it. SQL Server UPPER() - The SQL Server UPPER() function used to convert text to uppercase and return it.

SQL Scalar functions

SQL Scalar Functions - SQL scalar functions return a single value, base on the input value. The scalar functions include UCASE(), LCASE(), MID(), LEN(), SUBSTRING(), ROUND(), NOW(), DATETIME(), FORMAT().

Learn SQL Aggregate Functions

SQL aggregate functions - The sql aggregate functions returns a single value from values calculated group of rows, rather than on single row.They basically summarize the results of a particular column of selected data. AVG(), MAX(), MIN(), LAST(), FIRST(), COUNT(), SUM().