Error with stuff function; its cutting of my commands.

Question

Error with stuff function; its cutting of my commands.

Viewing 4 posts - 1 through 5 (of 5 total)

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

Why are you using STUFF anyway?

SSMS won't show all the characters in a varchar(MAX), you need to export them to some client that will show them (or check this article http://www.sqlservercentral.com/articles/T-SQL/72129/).

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

jancas08 Old Hand Points: 316 More actions · Answer 2

Well on the forum, they suggested to use stuff. I will look at the link you provided. If I have any questions I will post back.

Luis Cazares SSC Guru Points: 183706 More actions · Answer 3

People usually use STUFF in the code you're using to eliminate the first comma. Since you're not eliminating any character, there's no need to use it.

Be sure to understand the code you're using. Ask as many questions as needed when obtaining a code from a forum. Here we are happy to help you.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

jancas08 Old Hand Points: 316 More actions · Answer 4

Thanks for some reason I thought stuff was similar to concatenate, but I I looked it up and I see what you are saying.