---

Search posts under SQL Server:

---

Selecting all columns in SQL Server

How to select all columns and records from the database table in SQL Server?

To get all columns and records from the database table, we can use “*” with the SELECT statement.

SELECT * FROM PersonalDetails

Execution of above statements in query window will show all records and columns data of the PersonalDetails table.