Database.Guide – Page 299

SQL BETWEEN Operator for Beginners

December 1, 2020 by Ian

In SQL, the BETWEEN operator allows you to check for values that are within a given range.

The BETWEEN operator specifies a range to test, and it returns TRUE when the operand is within the range of comparisons.

SQL AND Operator for Beginners

November 30, 2020 by Ian

In SQL, the AND operator allows you to check for multiple conditions when filtering your queries.

The AND operator combines two Boolean expressions and returns TRUE when both expressions are TRUE.

SQL OR Operator for Beginners

November 30, 2020November 30, 2020 by Ian

In SQL, the OR operator allows you to use alternative conditions when filtering your queries.

The OR operator combines two conditions, and returns TRUE when either of the conditions is TRUE.

SQL EXISTS Operator for Beginners

September 17, 2024November 30, 2020 by Ian

In SQL, the EXISTS operator specifies a subquery to test for the existence of rows. It returns TRUE when the subquery returns one or more rows.

A subquery is a query that is nested inside another query (or even another subquery)

This article contains some basic examples of the EXISTS operator.

SQL IN Operator for Beginners

September 17, 2024November 30, 2020 by Ian

In SQL, the IN operator allows you to filter your query results based a list of values.

You can also use it to match any value returned by a subquery (a subquery is a query that’s nested inside another query).

SQL LIKE Operator for Beginners

April 13, 2021November 29, 2020 by Ian

In SQL, the LIKE operator allows you to do pattern matching. It determines whether a specific character string matches a specified pattern.

A pattern can include regular characters and wildcard characters.

SQL CREATE TABLE … AS SELECT Statement

October 30, 2022November 29, 2020 by Ian

The SQL CREATE TABLE ... AS SELECT statement enables you to insert the results of a query into a new table.

SQL SELECT INTO Statement

November 29, 2020 by Ian

The SQL SELECT INTO statement is a Sybase extension that can be used to insert the results of a query into a table (or a variable, depending on the DBMS).

SQL INSERT INTO… SELECT Examples

November 29, 2020November 28, 2020 by Ian

The SQL INSERT statement is most commonly used to insert individual rows into a table.

But you can also insert the results of a query into a table. This means that you can insert multiple rows at once (as long as they’re returned by the query).

Execute a Trigger Only When Certain Columns are Updated (SQL Server)

November 27, 2020 by Ian

SQL Server has the UPDATE() function that you can use within your DML triggers to check whether or not a specific column has been updated.

While this function only accepts one column, there’s nothing to stop you from including multiple UPDATE() clauses with AND or OR to test for multiple column updates.