---

Search posts under SQL Server:

---

Select sql statement in SQL Server

How to select data from SQL Server database table using sql statement and ui?

To read data from SQL Server database, we use SELECT statement.

Using SQL Script

SELECT * FROM MyDetails

Using SQL Script – Column wise

SELECT AutoId, FullName, City FROM MyDetails

In above scripts, MyDetails is the name of the database table, AutoId, FullName and City is the name of the columns into this database table.

Through Sql Server Management Studio (SSMS) menus

Right click the database table and choose “Select Top xxxx Rows that brings a query window and result in the right side panel of the SSMS.