SQL交叉表实例.docVIP

SQL交叉表实例 [ 2005-4-8 10:36:35 | By: 孤独的猎人 ] SQL交叉表实例 建表：在查询分析器里运行：CREATE TABLE [Test] ([id] [int] IDENTITY (1, 1) NOT NULL ,[name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [subject] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[Source] [numeric](18, 0) NULL ) ON [PRIMARY]GO INSERT INTO [test] ([name],[subject],[Source]) values (N张三,N语文,60) INSERT INTO [test] ([name],[subject],[Source]) values (N李四,N数学,70) INSERT INTO [test] ([name],[subject],[Source]) values (N王五,N英语,80) INSERT INTO [test] ([name],[subject],[Source]) values (N王五,N数学,75) INSERT INTO [test] ([name],[subject]