T-SQL

SELECT – Return results from all columns

There is a simple way to return information from all the columns in SQL.

SELECT * FROM INSERTTABLENAME

For example

SELECT * FROM HumanResources.Department

1

As you can see the query returned 16 rows of information with all the columns.

Leave a Reply