Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Display More Than 8000 Characters (SQL Spackle) RE: Display More Than 8000 Characters (SQL Spackle)

  • January 27, 2011 at 10:34 am

    #1279219

    Matt Whitfield (1/27/2011)

    Good article Jeff, nice one.

    It does surprise me, though, that it's even necessary. I mean, it's 2011...

    I guess that sort of thing is why I very rarely use SSMS... 🙂

    Hi Matt,

    Long time no "see". Thanks for stopping by and thanks for the compliment.

    I agree. You'd think there'd be an easier way to do such a thing in SSMS.

    If you're not using SSMS, are you using VS? Since I'm such a "data troll", I never get into VS. Assuming you're using VS, how does one see more than 8K characters from a column there?

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