STUFF & ISNULL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » STUFF & ISNULL

STUFF & ISNULL

Rate Topic

Display Mode

Topic Options

Author

Message

mubarak.a

Posted Monday, October 08, 2012 5:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 2:12 PM
Points: 5, Visits: 70

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.

Post #1369730

Phil Parkin

Posted Monday, October 08, 2012 5:53 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:39 AM
Points: 4,247, Visits: 9,500

mubarak.a (10/8/2012)

Books Online is a good place to start - and post back with any specific questions you may have afterwards.

STUFF
ISNULL

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1369740

ChrisM@Work

Posted Monday, October 08, 2012 6:02 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:27 AM
Points: 5,618, Visits: 10,990

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
Exploring Recursive CTEs by Example Dwain Camps

Post #1369744

robert.gerald.taylor

Posted Monday, October 08, 2012 6:15 AM

Right there with Babe

Group: General Forum Members
Last Login: Today @ 12:57 PM
Points: 740, Visits: 790

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

Look at: http://johnnycoder.com/blog/2006/09/05/concatenate-multiple-rows-into-a-single-string/

HTH,
Rob

Post #1369759

« Prev Topic | Next Topic »

Permissions