SqlServer中行变列

     例如创建一个表
                 create table stz
              (
             stuNO int  primary key ,
             subject nvarchar(20) not null,
             score int not null
              )
              insert into stz values(1000 ,'数学',90)
              insert into stz values(1001,'语文',90)
              insert into stz values(1002,'英语',90)
              insert into stz values(1001 ,'数学',90)
              insert into stz values(1002,'语文',90)
              insert into stz values(1000,'英语',90)
              insert into stz values(1002 ,'数学',90)
              insert into stz values(1000,'语文',90)
              insert into stz values(1001,'英语',90)
--              现在的情况是
            select * from stz;
                    &n