mohd.nizamuddin (1/17/2010)
Very nice and informative article...This is what we do in real life as well (Use of SELECT *). Even though we hear from everybody that to avoid SELECT * always.
So, if we make practice of writing SELECT col1, col2, col3,.... then we would not get that problem.
Enjoy.
Sorry for 2 responses. More thoughts occurred as the coffee kicked in.
I "always" 😉 start to worry when someone used the phrase "always", there are always reasons why always is never appropriate. (Same goes with "never"). Sometimes it is just the thing to do.
When needing to "select col1, col2, etc." I use the Management Studio tactic of "Script table as->Select into->new query window" and then just hack out any columns I do not want. It "Always" works for me.
<><
Livin' down on the cube farm. Left, left, then a right.