Monthly Archives: July 2015

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().

How to use SQL TOP Clause

SQL TOP Clause - The TOP Clause is used to return a TOP N number records from a table. The TOP clause is used to specify the number of record to return.

How to use SQL WHERE Clause

Learn SQL WHERE Clause - The SQL WHERE Clause is used to specify the condition while make action like Select, Update and Delete operation on Database Table.

How to use SQL ORDER BY Clause

SQL ORDER BY Clause - is used to sort the records in ascending or descending order, based on one or more columns. By default records sort order is ascending order.

How to Set Session Timeout in ASP.Net using web.config.

How to set session timeout in asp.net using web.config file. How to set session expire property in web.config file.