SQL - Coding Is Life

Consuming Stored Procedure using Entity Framework in .Net Core

In this article, We can learn how to consume Stored Procedure (SP) using Entity Framework in .Net Core. I will show you how to do […]

Import SQL Database in SSMS from Local Machine

In this article, We learn how to Import SQL Database in SSMS in Local Machine. I will show how to do it, and just follow […]

Export(Backup) SQL Database in SSMS in Local Machine

In this article, We learn how to export(Backup) SQL Database in SSMS in Local Machine. I will show how to do it, and just follow […]

Angular CRUD with .NET Core API

In this article, We create a full tutorial of Angular CRUD with .NET Core API. I will show how to do it, and just follow the steps clearly. In this article we have two deferent kind of topics, first is the Angular CRUD and second is the .NET Core API.

Create Table in MSSQL using T-SQL Command/Statement

In this blog, I will show how to create Table in MS SQL using T-SQL command. explain how its works and why we need to […]

Use UNION Operator in SQL

In this blog, I will show how to use and where to use UNION in SQL. Explain How its work and why we need to use […]

Calling a Web Services or Rest API from T-SQL using MSXML

In this blog, I will show step by step how to call a Web Service or Rest API in your T-SQL. explain how its works […]

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.

use Sub-Query in SQL Query

In this blog, I will show step by step how to use SQL Sub-Query in SQL Query. explain how its works and why we need […]

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.