SQL Server

This article explains how to use Foreign Key with Cascade Delete in SQL Server with syntax and examples.

The following tutorial will explain the Foreign Key foreign key with the Set Null On Delete constraint in SQL Server.

Learn how to delete foreign keys in SQL Server with syntax and examples.

If you want to disable foreign keys in SQL Server, this is how.

This article explains how to enable a foreign key created in SQL Server.

The IN condition is used in SQL Server (Transact-SQL) to minimize the need to use too many OR conditions.

The IS NULL condition is used to check NULL values ​​in SQL Server.

This SQL Server tutorial shows how to use the IS NOT NULL condition along with specific syntax and examples.

The LIKE condition in SQL Server (Transact-SQL) allows the use of wildcards in the WHERE clause.

The NOT condition in SQL Server (Transact-Server) is also called the NOT operator, which is used to negate conditions in SELECT, INSERT, UPDATE, and DELETE statements.

ALIASES in SQL Server is used to create temporary names (called aliases) for columns or tables.

JOIN is used to retrieve data from multiple tables, occurring when two or more tables are connected together in an SQL statement.

In SQL Server (Transact-SQL), BETWEEN conditions are used to retrieve data in a range.

In SQL Server (Transact-SQL) the UPDATE command is used to update the existing records on a table in a SQL Server database.

The INSERT statement in SQL Server (Transact-SQL) is used to insert one or more records into a table.

The DELETE statement in SQL Server (Transact-SQL) is used to delete one or more records from a table in SQL Server.

The TRUNCATE TABLE statement is used to delete all records from a table in SQL Server.

In SQL Server (Transact-SQL) condition EXISTS is correct to associate with the internal query (subquery).

The GROUP BY clause in SQL Server (Transact-SQL) is used in the SELECT statement to retrieve data from multiple records and result groups into 1 or more columns.

The HAVING clause is used in conjunction with the GROUP BY clause in SQL Server (Transact-SQL) to limit the group of returned rows, only when the condition is met is TRUE.