我想在行数据库列中显示详细信息，如何使这成为可能？ [英] I wanted display the details from database column in row fromat , How can make this possible?

问题描述

下面是表格

----------------------------------- ---

id | num | val

1 | num1 | val1

2 | num1 | val2

3 | num1 | val3

4 | num1 | val4

5 | num1 | val5





我想显示这个链接



num1 | val1 | val2 | val3 | val4 | val5

如何实现这一目标？

解决方案

看看这里：

在SQL中创建动态PIVOT查询的脚本服务器 [ ^ ]

转动动态方式 [ ^ ]

带有动态列的数据透视表SQL Server 2005 [ ^ ]



静态形式的枢轴：

  SELECT  num，[val1]，[val2]，[val3]，[val4]， [val5] 
  FROM （
  SELECT  num，val 
 < span class =code-keyword> FROM  TableName 
） AS  DT 
 PIVOT（MAX（val） FOR  num  IN （[val1]，[val2]，[val3]，[val4]，[val5]））< span class =code-keyword> AS  PT 

follwing is the table
--------------------------------------
id | num |val
1 | num1 |val1
2 | num1 |val2
3 | num1 |val3
4 | num1 |val4
5 | num1 |val5


And I wanted to display link this

num1 | val1|val2|val3|val4|val5
How can I achieve this?

解决方案

Have a look here:
Script to create dynamic PIVOT queries in SQL Server[^]
Pivoting the Dynamic Way[^]
Pivots with Dynamic Columns in SQL Server 2005[^]

Static form of pivot:

SELECT num, [val1], [val2], [val3], [val4], [val5]
FROM (
    SELECT num, val
    FROM TableName
) AS DT
PIVOT (MAX(val) FOR num IN([val1], [val2], [val3], [val4], [val5])) AS PT

这篇关于我想在行数据库列中显示详细信息，如何使这成为可能？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！