Table of Contents
This is all about selecting data from database server using SQL command.
What is SQL
SQL (pronounced “ess-que-el”) stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.
Microsoft SQL Server
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.
What is Microsoft SQL Server used for?
The core component of Microsoft SQL Server is the SQL Server Database Engine, which controls data storage, processing and security. It includes a relational engine that processes commands and queries and a storage engine that manages database files, tables, pages, indexes, data buffers and transactions.
SELECT Syntax
Select All syntax;
In (*), it means all column in particular table
SELECT *
FROM table_name;
In this part, column’s stated after SELECT statement will be the only colomn selected.
SELECT column1, column2, column2, ...
FROM table_name;
Example: Select Statement
- if you want to select all column in particular table.
SELECT * FROM Customers;
- if you want to select only “FirstName, Lastname, Age, Gender”;
SELECT FirstName, Lastname, Age, Gender
FROM Customers
Retaled Topics
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 […]
Related Topics
Generate Entity Framework Migration Script
In this article, We learn how to create or generate Migration Script. I will show how to do it, and just follow the steps clearly. […]
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 […]
Cannot be loaded because its operation is blocked by software restriction policies, such as those created by using Group Policy
In this article we learn how to address if you encounter this issue in your development journey. I will show you how, Just follow the […]