Post reply

Why doesn’t ISNUMERIC work correctly?

  • October 28, 2010 at 2:42 am

    #228450

    It's an old subject, I know. Still, the problem of using ISNUMERIC as an "IsAllDigits" function still has people thinking that ISNUMERIC doesn't work correctly. I submitted another "SQL Spackle" article on the subject. I had written it as a response to a post a long time ago. I updated the verbage and one of the examples and submitted it via the "write for us" link.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • October 28, 2010 at 10:41 pm

    #1243982

    So you've got two SQL Spackle articles already done? You really are quite the hot-shot.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • October 29, 2010 at 6:08 am

    #1244084

    WayneS (10/28/2010)

    So you've got two SQL Spackle articles already done?

    I do. I also ran into a couple of problems at work recently and solved them. They're also something that a lot of people know about but would still make good SQL Spackle articles. Since they're so short, I should be able to post what they are in this forum section over the weekend and submit them.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply