我使用的是MS SQL Server 2005.对于SQL引擎而言,
SELECT * FROM MyTable;
和
SELECT ColA, ColB, ColC FROM MyTable;
When ColA, ColB, 和 ColC represent every column in the table?
If they are the same, is there a reason why you should use the 2nd one anyway? I have a project that's heavy on LINQ, 和 I'm not sure if the st和ard SELECT * it generates is a bad practice, or if I should always be a .Select() on it to specify which cols I want.
EDIT: Changed "When ColA, ColB, 和 ColC are all the columns to the table?" to "When ColA, ColB, 和 ColC represent every column in the table?" for clarity.