Lilf

摘要： 成绩纵向对比Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--CREATEPROCEDUREselect_MarkContrastByTime@currentSemesterint,@currentAchievementvarchar(50),@seme... 阅读全文

摘要： 成绩分段统计Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--CREATEPROCEDUREselect_MarkContrastByClass@semester_idint,@grade_idint,@achievementNamevarchar(50... 阅读全文

摘要： 经常有人提到,用动态生成SQL语句的方法处理数据时,处理语句超长,无法处理的问题/*-- 数据测试环境 --*/if exists (select * from dbo.sysobjects where id = object_id(N'[tb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [tb]GOcreate table t... 阅读全文