T-sQL USing STUFF

Question

T-sQL USing STUFF

Steve Jones - SSC Editor

SSC Guru

Points: 736173
More actions
October 10, 2019 at 5:30 pm

#3687802

Had a request for a tutorial on how to use the STUFF() command with a few examples

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

drew.allen SSC Guru Points: 76985 More actions · Answer 1

I've seen several posts where people think that STUFF() is doing concatenation, so I'm wondering if the request was really for how to use XML concatenation. Any sense from the original request?

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

Steve Jones - SSC Editor SSC Guru Points: 736173 More actions · Answer 2

No, it was in response to some post, but I can't remember which one. I think they got some code, probably from you, and didn't quite understand how STUFF() works.

drew.allen SSC Guru Points: 76985 More actions · Answer 3

I can do it.

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

Steve Jones - SSC Editor SSC Guru Points: 736173 More actions · Answer 4

I know you can. Hoping you do, but no hurry. Feel free to teach it how you think best. If you want two articles (one on Stuff, one on common uses), that's fine.

Brahmanand Shukla SSC Eights! Points: 990 More actions · Answer 5

Hi Steve,

Recently wrote an article on Stuff() function. I hope you will find it inline with your expectation!

https://sqlservercarpenter.com/2020/02/04/demystifying-stuff-function/

SQL Server Carpenter - Consultant & Trainer
Author of Learn T-SQL from Scratch

Steve Jones - SSC Editor SSC Guru Points: 736173 More actions · Answer 6

Thanks, but these threads are not asking for help. They are asking for authors to write articles for this site.