What is the usage of .* into sql

Question

I review an stored procedure like this:

SELECT Mold.*, Cat.IdMope
            INTO #tmpMolde
            FROM proove.tmpMolde Mold
        LEFT JOIN pere.srcMaquina Cat ON Mold.maq= Cat.maq;

As you an see it say Mold.* but I really don´t know what is the usage of .* can anyone explain me? Regards

This is adding all columns from the Mold table to a temporary table. — abhi, May 09 '17 at 21:25

Milney · Accepted Answer · 2017-05-09T21:26:09.460

4

It just means all fields from that table. Note: This is bad practice and should be replaced with an explicit list of columns. This helps with robustness and indeed performance so is worth doing.

edited May 09 '17 at 21:26

answered May 09 '17 at 21:25

Milney

6,253
2
19
33

Yes, see answers in this question for details: http://stackoverflow.com/questions/3639861/why-is-select-considered-harmful – Milney May 09 '17 at 21:30

What is the usage of .* into sql

1 Answers1