smgilbert101 (10/16/2013)
SELECT * FROM can be acceptable and a normal requirement (think data warehousing, integration and application services). A common example is selects all states and provinces to generate a list for a form prompt...
In my opinion no. If you want to select all items then you are talking about rows not columns i.e. no WHERE clause not all columns.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!