Home Forums SQL Server 2005 T-SQL (SS2K5) STUFF & ISNULL RE: STUFF & ISNULL

  • October 8, 2012 at 6:02 am

    #1546663

    mubarak.a (10/8/2012)

    Hi,

    I'm new in SQL Server, i want the working process of STUFF & ISNULL. How it works & how it concatenate the row level data into a single data? Please...

    Thanks in advance

    Regards,

    Mohammed Mubarak.

    Concatenation generally involves more than simply STUFF and ISNULL. Can you post an example of the type of query you are referring to?

    “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