In this article, we will learn DELETE CASCADE rules in SQL Server with foreign key constraint having multiple examples.
OVERVIEW – SQL DELETE CASCADE
1. DELETE CASCADE : In the SQL server, when we create a foreign key using the delete cascade option, it deletes all the related rows from the child table when the referenced row is deleted from the parent table having primary key constraint.
The following are the SQL scripts that create a parent (Departments), child (Employees) table, and a foreign key on the child table without the delete cascade rule.
Introduction : In this SQL Operators article, we will learn all about SQL Comparison operators in details with multiple examples.
SQL Server Comparison Operators
In SQL Server, the comparison operators are useful to compare one expression with another expression using mathematical operators. Comparison operators return true or false based on the comparison. The following are the list of different type of comparison operators available in SQL.
Consider X is the variable and the value assigned to X = 5 ;
Less Than (<) Operator
X < 10 (returns true)
Greater Than (>) Operator
X > 10 (returns false)
Less Than or Equal To (<=) Operator
X <= 10 (returns true)
Greater Than or Equal To (>=) Operator
X >=5 (returns true)
Equal (=) Operator
X = 5 (returns true)
Not Equal (!=) Operator
X != 5 (returns false)
Not Equal (<>) Operator
X <>5 (return false)
SQL Comparison operators
The following are the examples of the above SQL comparison operators.
In this article, we are going to talk about the use of Inheritance in C# with examples.
What is Inheritance?
Inheritance is a kind of relationship or association between two classes that allows one class to inherit code from the other class. Inheritance means a parent-child relationship where we can create a new class by using the existing class code.
Inheritance is the IS-A type of relationship. (Example: Apple is a fruit, Car is a Vehicle)
In Inheritance, the class whose features are inherited is known as parent class(or a generalized class, superclass, or base class).
The class that inherits the existing class is known as child class(or a specialized class, derived class, extended class, or subclass).
In this article, we are going to talk about the use of properties in C# with examples.
What are the Properties in C#?
A Property in C# is an extension of a field that provides a public way for the classes to read, write, and expose the private fields while hiding the implementation details.
Properties in C# are actually a special kind of getter and setter methods wrapped around a private variable. A get property accessor is used to retrieve the value and the set accessor is used to assign the new value. In simple words, Property in C# is used to get and set the data from the private field in a class.