What will be the output of the below TSQL Script?

DECLARE @t TABLE(Chars VARCHAR(20))
INSERT INTO @T SELECT 'D' UNION ALL SELECT 'N' UNION ALL SELECT 'F'

SELECT Chars Data
FROM @T
FOR XML PATH('')

 Posted by Rajnilari2015 on 3/14/2017 | Category: Sql Server Interview questions | Views: 5559 | Points: 40
Select from following answers:
  1. DNF
  2. D N F
  3. <Data>D</Data><Data>N</Data><Data>F</Data>
  4. <Data>D</Data><Data>N</Data>
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response