SQLServerLog.com

SQLServerLog.com - Database Tips, Techniques and Tutorials

0

SQL Commands / SQL Programming / SQL Server

SQL RIGHT JOIN

300viewsSQL 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

428viewsSQL 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

351viewsSQL 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

630viewsSQL 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

471viewsSQL 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

321viewsSQL 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...