SQL – EXEC Keyword
The EXEC keyword is used to execute a stored procedure.
SQL – EXISTS Keyword
The EXISTS keyword tests for the existence of any record in a subquery, and returns “true” if the subquery returns one or more records.
SQL – FOREIGN KEY Keywords
The FOREIGN KEY keywords are a key (a field or fields in one table that refers to the PRIMARY KEY in another table) used to link two tables together.
SQL – FULL OUTER JOIN Keywords
The FULL OUTER JOIN keyword returns all rows when there is a match in either the left table or right table.
SQL – GROUP BY Keywords
The GROUP BY keywords are used to group the result set (used with aggregate functions: COUNT, MAX, MIN, SUM, AVG).
SQL – IN Keyword
The IN keyword allows you to specify multiple values in a WHERE clause, and is shorthand for multiple OR conditions.
SQL – INDEX Keyword
Indexes are used to speed up the retrieval of data (searches/queries) from the database.
SQL – INNER JOIN Keywords
The INNER JOIN keywords returns rows that have matching values in both tables.
SQL – INSERT INTO SELECT Keywords
The INSERT INTO SELECT keywords copies data from one table and inserts it into another table.
SQL – IS NOT NULL Keywords
The IS NOT NULL keywords are used to test for non-empty values (NOT NULL values).
SQL – JOIN Keyword
The JOIN keyword is used in an INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN to return matching rows from two tables.
SQL – LEFT JOIN Keywords
The LEFT JOIN keywords return all rows from the left table, and the matching rows from the right table (NULL from the right side if there is no match).
SQL – LIKE Keyword
The LIKE keyword is used in a WHERE clause to search for a specified pattern in a column. It can use two wildcards: % and _.
SQL – NOT Keyword
The NOT keyword is used with other SQL keywords to only include rows where a condition is NOT true.
SQL – NOT NULL Keywords
The NOT NULL keywords enforces a column to NOT accept NULL values (a record cannot be inserted/updated without adding a value to that field).