sql server 2008如何将同一张表两行变成另一张表或视图的两列答:Create Table #TableA (A varchar(10),B varchar(10),C varchar(10))insert into #TableA(A,B,C) values ('A1','B1','C1'),('A2','B2','C2')select * from #TableA select pvt.[1] as D,pvt.[2] as Efrom (select unpvt.orders as orders,unpvt.Col as Col,unpvt.ID ...