SQL交叉表的实例(横表转纵表)
摘要：--建表SQLCREATE TABLE [Test] ( [id] [int] IDENTITY (1, 1) primary key, [name] [nvarchar] (50) , [subject] [nvarchar] (50), [Source] int,)ON [PRIMARY]GOINSERT INTO [test] ([name],[subject],[Source]) values (N'张三',N'语文',60)INSERT INTO [test] ([name],[subject],[Source]) values (N'李四&#
阅读全文
posted @ 2011-09-13 18:11
