摘要:
行转列建表Create table StudentSubject(SId int identity(1,1)not null PRIMARY KEY, SName varchar(50) null, Subject varchar(50) null, Score numeric(18,2)null)插入数据INSERT INTO StudentSubjectselect '张三','语文',90union all select '李四','语文',87union all select '王五','语文 阅读全文
posted @ 2010-12-20 17:18 疯狂的猫咪 阅读(354) 评论(1) 推荐(1)