In Sql server
* means it reurns all the columns from table.
Example:-
Let assume you have Employee table and in this table you have 1000 records . So, If you write query “SELECT * FROM EMPLOYEE “
It will return all the column from EMPLOYEE table.
Originally published at https://sqlsensationforu.blogspot.com.