1) Select all the columns from a table/ View by using *
You can always use Select * from SchemaName.TableName to display data for all the columns from a table or view. When you use * in Select query, it return you all the columns from table or view.
Let's say that if I want to select all the columns from dbo.TotalSale table , I can use below query
|How to select data for all the columns from SQL Server Table by using *|
|Select all the Columns quickly for a table for Select Query in SQL Server|
|How to generate Select Query with required Columns quickly in SSMS - SQL Server Tutorial|
|How to use Select Top X rows to generate select query with all the column names in SQL Server|