DBA-s and database developers frequently use SELECT * as part of their daily work. It is a great shorthand.
However, it is undesirable
to include select * from in your PRODUCTION code or stored procedure
because if a column is added or deleted, you can expect a sure
you can easily get a column list. Just cut and paste it, add commas
and you have the select with the explicit column list.
You can also do
this from SSMS Object Explorer by scripting out the table.
Similar consideration for the INSERT statement: specific column list should be included.
Caution: Avoid Using SELECT * in a SQL View