What will be the output of

DECLARE @Name VARCHAR(30) = 'FirstName MiddleName LastName'
SELECT
CONCAT(
PARSENAME(REPLACE(@Name,' ','.'),3),',',
PARSENAME(REPLACE(@Name,' ','.'),2),',',
PARSENAME(REPLACE(@Name,' ','.'),1)
)

Posted by Rajnilari2015 on 10/28/2015 | Category: Sql Server Interview questions | Views: 1563 | Points: 40

Select from following answers:

Show Correct Answer

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What will be the output of DECLARE @Name AS VA ...

Next > : What will be the output of SELECT PARSENAME(&# ...

More Interview Questions by Rajnilari2015

Latest Interview Questions