单行到多行

本文介绍了单行到多行的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有Table Servive，我只是想要将列标题作为描述和值作为下一栏

[IncomeHeadID] [InventoryControlHeadID]，[CostOfGoodLabHeadID]，[CostOfGoodHeadID] [CashHeadID] 12 11 22 44 44

i想要这样

描述值 [IncomeHeadID] 12 [InventoryControlHeadID] 11 [CostOfGoodLabHeadID] 22 [CostOfGoodHeadID] 44 [CashHeadID] 44

感谢提前...

解决方案

如果您知道标题名称或想要更改它们，请执行以下操作： 选择收入头ID作为incomeHeadIdDescripton ，IncomeHeadId， 库存控制头ID作为IncomeControlHeadIdDescription，IncomeControlHe adId 来自表1; 不确定是否可以从查询动态加载列名，但如果使用数据库组件则可以...

查看过去的答案：如何将列名称作为具有值的行 [ ^ ]

我不确定此链接是否会为您提供准确的解决方案，但这可以帮助你解决这个问题。 这是链接， msdn.microsoft/en-us/library/ms177410（v = SQL.105）的.aspx [ ^

hi , I have Table Servive,i just Wanto retreve Column headings As Description and Values As Next Column

[IncomeHeadID][InventoryControlHeadID],[CostOfGoodLabHeadID] ,[CostOfGoodHeadID] [CashHeadID] 12 11 22 44 44

i want like this

Description Value [IncomeHeadID] 12 [InventoryControlHeadID] 11 [CostOfGoodLabHeadID] 22 [CostOfGoodHeadID] 44 [CashHeadID] 44

thanks In advance...

解决方案

If you know the heading names or want to change them just do this: Select "income head Id" as incomeHeadIdDescripton, IncomeHeadId, "Inventory control head Id" as IncomeControlHeadIdDescription, IncomeControlHeadId From table 1; Not sure if you can load column names dynamically from a query, but could if you used a database component...

See past answer: How to get Column names as rows with values[^]

I am not pretty sure that this link would give you the exact solution, but this would help you to solve the requirement. Here is the link, msdn.microsoft/en-us/library/ms177410(v=sql.105).aspx[^]