• jfogel (7/15/2013)


    Of course a postal code field should be nvarchar(4000)! You never know what the future holds.

    BWAAA-HAAAA!!!! That and an "IsActive" column were the examples I used put put a little heat under their kettles. I couldn't believe it when the Lead Developer recited Knuth's famous saying to explain why it was done and he did it with a perfectly serious face on. As a bit of a side bar, this is the guy that introduced himself to me as "I'm the Jeff Moden of the GUI world." My comment after his Knuth explanation was "you can't be... I'm not [font="Arial Black"]that [/font]bad". :-P:-P:-P

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