Home Forums SQL Server 2008 T-SQL (SS2K8) Alphanumeric number generation RE: Alphanumeric number generation

  • October 29, 2012 at 6:37 am

    #1553698

    Jeff Moden (10/29/2012)

    Eugene Elutin (10/29/2012)

    Jeff Moden (10/27/2012)

    I wonder how many 3 and 4 letter swear words such a proccess will actually spell out...

    Actually it depends how you take it, at least some of them will be easy to remember :-D.

    By the way, English as a language is not very rich with such words in compare with some other languages (eg. world-champion in this business: Russian :hehe:)

    That's why we shouldn't be Russian to use incrementing Alpha-Numerics. 😛

    <<Groan>> Jeff that's awful!

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden