如何在SQL 2000中获取多列中的单列值 [英] How to get single column values in a multiple columns in sql 2000

问题描述

现在，我在单打列中有32行，如何在每个不同的单列中获取32个值，我需要使用SQL 2000将单列中的32个行值转换为每列中的一个值.

Hi,
Now i have 32 rows in singles column, how can i get 32 values in a every different single column,i need to get 32 row values from single column into single value from each column, using SQL 2000.

推荐答案

您必须使用数据透视表.

请查看下面的线程. SatyaPriya Nayak的帖子将向您解释该链接中的所有内容.

http://www.c-sharpcorner.com/Forums/Thread/175401/__cs_myImageUpload.asp [ ^ ]

You have to use Pivot table.

Please look into the below thread. SatyaPriya Nayak''s post will explain you everything in that link.

http://www.c-sharpcorner.com/Forums/Thread/175401/__cs_myImageUpload.asp[^]

这篇关于如何在SQL 2000中获取多列中的单列值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！