Viewing 6 posts - 166 through 171 (of 171 total)
Thanks Jeff. I'll ponder and see if I prefer your way to my way. As someone once remarked, for each expert there's an equal and opposite expert (not...
September 29, 2014 at 7:58 am
Jeff Moden (9/29/2014)
September 29, 2014 at 6:37 am
Hugo Kornelis (9/26/2014)
September 29, 2014 at 1:39 am
Except that I would write
As you say, it's all preference. For simple queries such...
September 26, 2014 at 1:17 am
Far be it from me to disagree with a guru of your stature, but personally I find aliasing makes queries difficult to read. I only ever alias where strictly...
September 25, 2014 at 8:49 am
Can you explain why you aliased the sys.syscolumns table?
SELECT TOP 10
RAND( ROW_NUMBER() OVER (ORDER BY id))
is functionally identical, as far as I am aware.
September 25, 2014 at 3:04 am