Common Table Expression (CTE) in SQL Query

A Common Table Expression also called CTE in short form, is a temporary named result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement. The CTE can also be used in a View. In this article, we will see in detail how to create and use CTEs from our SQL Server.

Read More

Create SQL Views

A Views in SQL are kind of virtual tables. A view also has rows and columns as they are in a real table in the database. We can create a view by selecting fields from one or more tables present in the database. A View can either have all the rows of a table or specific rows based on certain conditions. Views are virtual tables that can be a great way to optimize your database experience. Not only are views good for defining a table without using extra storage, but they also accelerate data analysis and can provide your data extra security.

Read More

Create Stored Procedure in SQL

A stored procedure is a set of Structured Query Language (SQL) statements with an assigned name, which are stored in a relational database management system (RDBMS) as a group, so it can be reused and shared by multiple programs.

Read More

Create Project in ASP.Net Core WebApp

In this tutorial, I just want to show step by step and explained on how to create project in ASP.net Core Web Application (MVC). So that you can create and understand what is your doing. Lets Go..

Read More

ASP.Net CRUD using Entity Framework

In this tutorial,  I create a project in ASP.net CRUD Web Application using Entity Framework. This Project user can Create, Read(Display), Update, Delete data from Database using […]

Read More