I guess this is more of a question *if* this should be done, not *how* it is done.

I agree, Thomas!

...and besides another two points , feedback from the original questioner should always be there as to whether the problem...

GO is a batch separator. Your variable will be out of scope after a GO. You might also want to consider the use of sp_executesql as this one feature an...

However, the contest does generate more activity on the site and from what I have seen the replies are generally useful. Sometimes one person simply says that the previous...

The N' indicates unicode.

Now, that we got of a certain number of replies.

Should this be rewarded?

But good questions are equal to good answers, methinks

your avatar

I...

like...

That's what I meant to show in my post above.

It should also work with temp tables.

That's why I've posted it. It shouldn't be too hard too modify it to update a table.

After all the complaining:

Robert, you did a good job with this QOD!

My major concern is that this handling lead to posts which are aimed to help the original questioner, but were in fact poor advise (me always included!) and did the...

Although not what you asked for, this might give you some ideas.

/*

Name: Listet sämtliche Datenbank-Optionen auf

*/

SELECT LEFT(name,30) AS DB,

SUBSTRING(CASE status & 1 WHEN 0 THEN '' ELSE ',autoclose' END +

CASE...