Code666 (代码贴、代码片段)

[SQL] sql将查询结果的行转换成列 →→→→→进入此内容的聊天室

来自 , 2021-03-16, 写在 SQL, 查看 137 次.
URL http://www.code666.cn/view/06358599
  1. ( SELECT SA.AttributeName + ':' + SAV.AttributeValue + ', <br>'
  2.   FROM Core.ProductAttributeValue PAV
  3.   JOIN Core.AttributeValue SAV ON SAV.AttributeValueId = PAV.AttributeValueId
  4.   JOIN Core.Attribute SA ON SA.AttributeID = SAV.AttributeId
  5.   WHERE PAV.ProductID = P.ProductId AND PAV.Version = P.Version
  6.   FOR XML PATH('')) AS Attributes,    
  7.  
  8. --Simple Version
  9. (
  10.   SELECT T.ColToConcat + ","
  11.   FROM SubqueryTable T
  12.   WHERE T.Id = MainQuery.Id
  13.   FOR XML PATH('')
  14. ) AS Concat
  15. //SQL/2045

回复 "sql将查询结果的行转换成列"

这儿你可以回复上面这条便签

captcha

贴代码片段 - Code666