In this SQL tutorial, we will learn the basics and advanced concepts of SQL Server such as how to use the SQL language to create, store, retrieve and manipulate data in the SQL server.
In this article, We’ll go over the different types of views in SQL Server through examples. In addition, we will learn how to create, alter, update, and delete views in SQL Server.
Views in SQL Server are nothing more than virtual tables based on the result sets of SQL statements from one or more tables.
Continue reading “View In SQL | Types Of Views In SQL Server [2021]”
A trigger in an SQL Server is a special kind of stored procedure that is fired or triggered automatically when a given event such as Insert, Update, or Delete occurs against a table in a database.
Continue reading “SQL Server Trigger Update, Insert, Delete Examples”
In this article, we will learn DELETE CASCADE rules in SQL Server with foreign key constraint having multiple examples.
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.
Continue reading “SQL Delete Cascade – SQL query to delete parent-child referenced rows”
Continue reading “SQL Comparison Operators |SQL Less than Operator, Not Equal operators”
In SQL Server, a Primary Key is a field or column which uniquely identifies each and every record in a table.
A primary key can be created at the column or table level.
The following are the syntax to create a primary key in SQL server.
