Learn to use Union, Intersect, and Except Clauses

Union Intersect Except

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. This is introduced in SQL Server 2005. The number of columns and order of columns should be the same. The data types must be the same or least compatible. It filters duplicate records and selects only…

Read More

T SQL Advanced Tutorial By Sagar Jaybhay 2020

Sql-Server

In this article we will understand T SQL Advanced Tutorial means Transaction In SQL and Common Concurrency Problem and SQL server transaction Isolation level by Sagar Jaybhay What is the Transaction? A transaction is a group of commands that changed the data stored in a database. A transaction is treated as a single unit. The transaction ensures that either all commands will succeed or none of them. Means anyone fails then all commands are rolled back and data that might change is reverted back to the original state. A transaction…

Read More

Cursor In RDBMS By Sagar Jaybhay 2020

Sql-Server

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. The cursor is…

Read More

Subqueries & Correlated Subqueries SQL Server 2020

Sql-Server

In this article Sagar Jaybhay explain how to write Subqueries and Correlated Subqueries in SQL Server and What to choose for Performance Subquery or Join? Subqueries In SQL Server: Subqueries are enclosed in parenthesis. Subquery also called an inner query and the query which enclosed that inner query is called an outer query. Many times subqueries can be replaced with joins. Another example The above query is an example of use subquery in the select list. The above result can be achieved using join also see below query According to…

Read More

Route Parameter Constraints In Asp.Net Razor Pages

Asp.Net Razor Pages

In this article we will understand Route Parameter Constraints In Asp.Net Razor Pages by Sagar Jaybhay Route Parameter Constraints Route Constraints is a mechanism where it filters out or restricts unwanted route parameters to reaching out to PageModel methods. To add route constraints we need to add constraints in route template data. For example, if we want our id only accepts numeric value then for this is below code. Now we want to apply constraints with optional parameters then we need to use below syntax. Below is a list of…

Read More

Route Parameter In Razor Pages Sagar Jaybhay

Asp.Net Razor Pages

In this article we will understand Route Parameter In Razor Pages By Sagar Jaybhay. Route Parameter: Another way to pass value from is route template. If you see the above image you have seen that the id parameter is passed as a query string parameter. But we want to pass as route template to do this we need to add below code in our Display template of Details .cshtml page. By doing so our URL will become like below Here are URL contains id but not as a QueryString parameter.…

Read More

Query String Parameters In Razor Pages 2020

Asp.Net Razor Pages

In this article, we will understand Query String Parameters. How to Use Query String Parameters and How to Pass Query String Parameters In Asp.Net Razor Pages? Query String Parameters If we want to pass data from the Display template to Code behind file which is Page Model in our case then we can use the asp-data-parameter_name tag helper to pass data from the display template to the Page Model class. This parameter catches in OnGet or OnPost method. Now we have to achieve functionality like when we click on View…

Read More

Generic List Routing & Routing Constraints

Asp.Net Razor Pages

In this article we will understand How to display Generic List In Asp.Net Razor Pages? How Routing Works in Asp.Net Razor Pages ? How to apply Routing Constraints in Asp.Net Razor Pages by Sagar Jaybhay. Generic List Routing & Routing Constraints Now see below image we need to display employee list like this image. We have Employee property present in our Index page model we access this in our view. Now iterating over this list we apply some bootstrap CSS and formatting to display like below. Code in the Display…

Read More

What Is DataBase Normalization By Sagar Jaybhay

Normalization

In this article we will understand What Is DataBase Normalization ? Different Types of Normalization forms By Sagar Jaybhay. DataBase Normalization Database normalization is a process of organizing data and minimizing data redundancy which in turn ensures data consistency. The problem of data redundancies: Data is duplicated Disk space required more which is wastage Data inconsistency DML queries become slow(Insert, update, delete) Database normalization is a step by step process. There is 6 normal forms that start from 1st normal form to the 6th normal form. But most of the…

Read More

How to create Models In Asp.Net Blazor

Asp.Net Razor Pages

In this article you will understand How to create Models In Asp.Net Blazor By Sagar Jaybhay. In Asp.Net Razor pages we don’t have models folder now to perform CRUD operation we will create the Model Class Library Project in our application. By creating a class library project it is easily used in any other project like web API, asp.net mvc. Models In Asp.Net Razor Pages: In our, we added this.NetStandard class library projects with Employee as class and Department as an enum. Now we will create a DataAccess Layer in…

Read More