Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Stephen Lasham A Function Gotcha with the Use of an Asterisk RE: A Function Gotcha with the Use of an Asterisk
SuperDBA-207096
SSCrazy Eights
Points: 8176
More actions
April 30, 2008 at 5:27 am
#808937
All good, but in general, using Select * is a bad idea, even if you need all of the columns. Better to specify in case someone changes something in the underlying schema.
Using Select * can also burn you with views...