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 wolfram 阅读(352) 评论(0) 推荐(0) 编辑
