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:17 am

    #1279206

    samir-424465 (1/26/2011)

    We can use BCP utility to get the data of the table (queryout option). The contents of the file will have character field (with varchar(MAX) / nvarchar(MAX)) with all the data in it.

    Hi Samir,

    Thanks for stopping by with the tip. I absolutely agree with the above and there are many other methods you can use, as well. That also takes a bit more time than what I need to take when I'm just trying to do a simple check while writing code in SSMS. It can also require elevated privs and not everyone has the privs to run BCP nor write to disk from an SQL Server.

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