SQLServerLog.com

Author: Manzoor Siddiqui

0

SQL Commands / SQL Programming / SQL Server

SQL RIGHT JOIN

SQL RIGHT JOIN returns all the rows from the right table mentioned with the RIGHT JOIN clause. If there are no matching rows in left table then output rows will return NULL values. Syntax SELECT...

0

SQL Commands / SQL Programming / SQL Server

SQL LEFT JOIN

SQL LEFT JOIN returns all the rows from the left table mentioned with the LEFT JOIN clause. If there are no matching rows in right table then output rows will return NULL values. Syntax SELECT...

0

SQL Commands / SQL Programming / SQL Server

SQL INNER JOIN

SQL INNER JOIN clause is used to combine and extract rows from two or more tables by joining common field. This common field column is compared by comparison operators like =, <, >, <=,...

0

SQL Commands / SQL Programming / SQL Server

SQL JOINS

SQL JOIN clause is used to combine and extract rows from two or more tables by joining common field. These joins are specified with FROM or WHERE clause mostly. Kindly note that INNER JOIN clause...

0

SQL Commands / SQL Server

SQL LOWER() Function

SQL LOWER() function is used to convert character string from upper case to lower case. Syntax LOWER (CharacterString) Below is an example converting small letter character string to upper case. SELECT LOWER(‘SQLServerLog.com’) AS MyWebsite Upper...

0

SQL Commands / SQL Server

SQL UPPER() Function

SQL UPPER() function is used to convert character string from lower case to upper case. Syntax UPPER (CharacterString) Below is an example converting small letter character string to upper case. SELECT UPPER(‘sqlserverlog.com’) AS MyWebsite...