What will be the output of

DECLARE @string VARCHAR(20) = 'Hello how r u?'
SELECT STUFF(REPLICATE(',' + LEFT(@string,10),LEN(LEFT(@string,10)) - LEN(REPLACE(LEFT(@string,10), 'o', ''))),1,1,'')

Posted by Rajnilari2015 on 3/17/2017 | Category: Sql Server Interview questions | Views: 5303 | Points: 40

Select from following answers:

SELECT LEFT(@string,10)

returns Hello how

SELECT LEN(LEFT(@string,10)) - LEN(REPLACE(LEFT(@string,10), 'o', ''))

returns

We are now replicating the word Hello how 2 times by using

SELECT REPLICATE(',' + LEFT(@string,10),LEN(LEFT(@string,10)) - LEN(REPLACE(LEFT(@string,10), 'o', '')))

which returns ,Hello how ,Hello how

The stuff function removes the leading ,

SELECT STUFF(REPLICATE(',' + LEFT(@string,10),LEN(LEFT(@string,10)) - LEN(REPLACE(LEFT(@string,10), 'o', ''))),1,1,'')

resulting Hello how ,Hello how

Show Correct Answer

| Alert Moderator

Bookmark It

< Previous : Extension when LINQ to SQL is used in C#?

Next > : What is Live Unit Testing?

More Interview Questions by Rajnilari2015

Latest Interview Questions