Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications which may run either on the same computer or on another computer across a network.
Rebase current branch into main/dev branch in Visual Studio using git
In this article, we learn how to rebase current branch into main/dev branch in Visual Studio using git. I will show how to do it, […]
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 […]
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, […]
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 […]