sql - 如何获取此类数据？

Question

我有这样的数据:

+---------+---------+---------+-------+
| MAXIMUM | MINIMUM | SENSORS | TIME  |
+---------+---------+---------+-------+
|      10 |      12 |      14 | 13:12 |
|      80 |      70 |     100 | 14:54 |
+---------+---------+---------+-------+

但我需要这样的东西:

+---------+-------+
|    X    |   Y   |
+---------+-------+
| MAXIMUM | 10    |
| MINIMUM | 12    |
| SENSORS | 14    |
| TIME    | 13:12 |
| MAXIMUM | 80    |
| MINIMUM | 70    |
| SENSORS | 100   |
| TIME    | 14:54 |
+---------+-------+

如何获取这种数据有可能获取到数据吗？

Answer 1

另一种选择

示例

Select B.*
 From  YourTable
 Cross Apply (values ('MAXIMUM',convert(nvarchar(50),MAXIMUM))
                    ,('MINIMUM',convert(nvarchar(50),MINIMUM))
                    ,('SENSORS',SENSORS)
                    ,('TIME'   ,convert(nvarchar(50),[TIME],108))
             ) B(x,y)

返回

x          y
MAXIMUM    10
MINIMUM    12
SENSORS    14
TIME       13:12:00
MAXIMUM    80
MINIMUM    70
SENSORS    100
TIME       14:54:00