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 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
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, […]
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 […]
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 […]
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 […]
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. […]
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 […]