Very good question. For get a correct answer and point, you need to look as question very carefully.

keep it up !!! 🙂

:blush: I got the correct answer but chose wrong and lose easy point...

but thanks it's nice question and good start of week...

I think, this question is not well define. When you execute this code, it's execute and throw below error

Msg 217, Level 16, State 1, Procedure sp2, Line 5

Maximum...

Really very good Question.

same here 🙂

good one !!!

Hi,

i am not sure about correct answer. When i execute this T-sql in Sql server 2012.

It shows Level 14 ,State 1 and message = "why oh why do...

Good Question. Again come to know some basic.

keep it up.

Thanks

Nice question with having good basic information.

Good question. I learn something new !!!

Thanks

Theo,

It's really good script. i ran it and it works.

but i have one issue. After getting the result for script, i paste data in excel.

In excel it...

Very good question.

And way of explanation is awesome.

Thanks & keep it up!

Vinay 🙂

I think, i didn't take it seriously, and i got it wrong.

anyway good question.

really very interesting question. i think bol do have this kind of information.

You can also do this with help of below script:-

DECLARE @CommString Varchar(100) ='1,2,3,4,5,6,7,8,9,10'

SELECT CP_XML.Node.value('.','Varchar(max)') AS DATA FROM

(

SELECT DataIn_XML = Convert(XML,'<Node>'+REPLACE(@CommString,',','</Node><Node>')+'</Node>')

) AS...