In this article, we will understand Union, Intersect, and Except clause in SQL Server. Also, we will see the difference between Intersect and Union in SQL Server. Also, the difference between Join with Intersect by Sagar Jaybhay

The intersect operator retrieves the common records between the left and right queries of the intersect operator.

1. This is introduced in SQL Server 2005.
2. The number of columns and order of columns should be the same.
3. The data types must be the same or least compatible.
4. It filters duplicate records and selects only distinct records that are common in the left and right queries. …

In this article we will understand cursor in rdbms in our case we show example on SQL Server By Sagar Jaybhay. Also we will understand Merge statement in SQL Server and rerunnable SQL scripts and How to create a stored procedure with an optional parameter?

Cursors In RDBMS

In a relational database management system takes into consideration then it would process the data in sets inefficient manner.

But when you have a need to process the data row by row basis then the cursor is the choice. …

In this article you will understand importance of mainly used terms in Angular 9 by Sagar Jaybhay. You will understand Components, Modules, How angular 9 works?

Angular 9

Angular is binding frameworks. It helps us to bind view and model. In angular, you can have multiple apps inside the src folder.

Components

In angular, the binding code which binds the UI means our Html and Model is component. Here Component is the part of angular, which receives data from the UI and Sends data back to UI.

In an enterprise application, you can have a lot of views, lots of components and lots of models. …

In this article we will understand What is the purpose of Html helpers in MVC by Sagar Jaybhay.

What is an Html Helper?

Html helper is a method that is used to render HTML content in a view. Html helpers are implemented using an extension method.

If you want to create an input text box with id=email and name is email

<input type=text id=email name=email value=''/>

This is all Html we need to write by using the helper method it becomes so easy

@Html.TextBox('email')

It will generate textbox control whose name is email.

If we want to assign the value of the textbox with some initial value then use below method. …

In this article we will understand How Conventions Used In MVC to Find View By Sagar Jaybhay.

See the above image in this we are creating Index methods below is code for that.

public ActionResult Index(string EmpID) { Employee employee = new BusinessLogic .Business().GetEmployee(EmpID); return View(employee); }

In the above code, we don’t use view names we simply use view and pass employee object to that view. So the question is how asp.net MVC knows which view is call and display?

Which location asp.net MVC used to find view. For understanding this we create one method in our EmployeeController whose name is wheretofindview and simply return View is used but we never created a view for that by doing this we will understand from which location view is called. …

CTE (common table expression) and Updatable CTE you will understand this in this article by sagar jaybhay in depth.

CTE (common table expression)

CTE Introduced in the SQL serve r 2005.

CTE is like a temporary result set which is defined within the execution of the current context or execution scope of single select, insert, update delete and create view statement.

It is similar to a derived table and it is not stored as an object like other objects in the SQL server.

Remember CTE table is created with the keyword.

with CTEtable
as
(
select d.Department_Name as deptname, COUNT(e.empid) as empcount from Department as d
join Employee as e on d.DepartmentID=e.DepartmentID
group by d.Department_Name …

In this article we will understand Working With Multiple Tables In MVC(Asp.Net) By Sagar Jaybhay.

Working with Multiple Tables in MVC

Now we are creating an Employee table with the Department ID field added in the Employee table and another table is created which is Department below having syntax for both tables.

create table Employee (
	EmpID INT,
	EmpName VARCHAR(50),
	EmpSalary DECIMAL(8,2),
	EmpGender VARCHAR(50),
	EmpCity VARCHAR(50),
	EmpEmail VARCHAR(50),
	DepartmentID INT
);
create table Department (
	DepartmentID INT,
	DepartmentName VARCHAR(50)
);

For both table insert data script is attached to here

insert into Department (DepartmentID, DepartmentName) values (1, 'Product Management');
insert into Department (DepartmentID, DepartmentName) values (2, 'Engineering');
insert into Department (DepartmentID, DepartmentName) values (3, 'Business Development');
insert into Department (DepartmentID, DepartmentName) values (4, 'Support');
insert into Department (DepartmentID, DepartmentName) values (5, 'Testing');
insert into Department (DepartmentID, DepartmentName) values (6, 'Account');
insert into Department (DepartmentID, DepartmentName) values (7, 'Marketing');
insert into Department (DepartmentID, DepartmentName) values (8, 'Legal');
insert into Department (DepartmentID, DepartmentName) values (9, 'Human Resources');
insert into Department (DepartmentID, DepartmentName) values (10, 'Srcum Master');
insert into Department (DepartmentID, DepartmentName) values (11, 'Sales');
insert into Department (DepartmentID, DepartmentName) values (12, 'Research and…

In this article we will understand In Depth about Cookies in JavaScript. By reading this article you will able to create Cookies, Delete Cookie By Sagar Jaybhay.

If you see web application works on HTTP protocol and the HTTP protocol is a stateless protocol. The meaning of this is when we request some data, web page after filling some information on the webpage the webserver does not remember anything about that request after processing that request but we want our web application to remember users choice.

This means if I fill my first name on the page after the subsequent request the page should know what information I filled in that textbox but the page doesn’t remember that so why this happens because web pages use the HTTP protocol to serve the webpage and HTTP is stateless. …