JHPeng's Blog：宏觀篇。

SELECT *
  FROM
      (
        Select [number_1],[number_2],[number_3],[number_4],[number_5],[number_6],[number_sp] FROM [lotto].[dbo].[big_lotto]
      ) AS p
  UNPIVOT
      (
        [number] FOR [order] IN ([number_1],[number_2],[number_3],[number_4],[number_5],[number_6],[number_sp])
      ) AS pv

http://jengting.blogspot.com/2010/11/sqlpivot-unpivot.html