按年月统计并行列转换(mssqlserver2005):按年月统计并行列转换(ms sqlserver2005) 1 创建表 CREATE TABLE [dbo].[Orders]( [ID] [int] IDENTITY(1,1) NOT NULL, [Amount] [int] NULL, [Year] [int] NULL, [Month] [smallint] NULL, CONSTRAIN