摘要: Declare@tTable (IDint,FNamevarchar(20),CNamevarchar(20),CAgevarchar(20))InsertInto@tselect 1,'吴亮','吴1','3岁'Unionselect 1,'吴亮','吴2','5岁'Unionselect 1,'... 阅读全文
posted @ 2014-04-28 14:02 碘盐 阅读(117) 评论(0) 推荐(0) 编辑
摘要: declare @studentnumber int;select @studentnumber=count(1) from [HistoryScoreForEachItemOfStudents] select Name '姓名', t2.banji '班级',Testnumber '考号', sc... 阅读全文
posted @ 2014-04-28 14:00 碘盐 阅读(1385) 评论(0) 推荐(0) 编辑