Forum Replies Created

Viewing 6 posts - 166 through 171 (of 171 total)

  • RE: Random values

    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...

  • RE: Random values

    Jeff Moden (9/29/2014)


    Heh... I'm interested to know how or why you came up with this coding standard of generally avoiding aliases. I did my degree in the school of...

  • RE: Random values

    Hugo Kornelis (9/26/2014)


    ... my personal coding standard is to always use aliases for all tables in queries that use two or more tables, but use no alias in single-query tables...

  • RE: Random values

    Except that I would write

    SELECT

    FirstName,

    Surname,

    Address,

    EmailAddress

    FROM

    Person

    As you say, it's all preference. For simple queries such...

  • RE: Random values

    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...

  • RE: Random values

    Can you explain why you aliased the sys.syscolumns table?

    SELECT TOP 10

    RAND( ROW_NUMBER() OVER (ORDER BY id))

    FROM sys.syscolumns

    is functionally identical, as far as I am aware.

Viewing 6 posts - 166 through 171 (of 171 total)