Bug In Xml Path with "&"

Answers

• 

  

  0

  Sign in to vote

  Hi Kodamins,
  hope to helps:

  CREATE TABLE dbo.x(y NVARCHAR(255));
  
  
  INSERT dbo.x SELECT 'Sports & Recreation'
      UNION ALL SELECT 'x >= y'
      UNION ALL SELECT 'blat'
      UNION ALL SELECT '<hooah>';
  
  
  -- bad:
   SELECT STUFF((SELECT ',' + y
    FROM dbo.x FOR XML PATH('')), 1, 1, '');
  
  
  -- good:
   SELECT STUFF((SELECT ',' + y
    FROM dbo.x FOR XML PATH, TYPE).value('.[1]',
    'nvarchar(max)'), 1, 1, '');
  
  
   GO
    DROP TABLE dbo.x;

  
  

  
  

  
  

  • Edited by Enric Vives Saturday, July 23, 2016 2:23 PM
  • Proposed as answer by Albert_ Zhang Monday, July 25, 2016 1:46 AM
  • Marked as answer by Sam ZhaMicrosoft contingent staff Sunday, August 7, 2016 2:02 PM

  Saturday, July 23, 2016 2:22 PM