1、透视原理：就是将查询结果进行转置下面就举例来说明：执行下面语句：检查是否含有表 dbo.Orders，如果有就将表删除：1 if OBJECT_ID('dbo.Orders','U') is not null2 drop table dbo.Orders然后创建表dbo.Orders:1 create table dbo.Orders2 (3 orderid int not null primary key,4 empid int not null,5 custid int not null,6 orderdate datetime,7 qty int8 ) Read More
