sqlserver中能用when_sqlserver中case when用法小结
首先建表和插入数据语句: use Student go create table Score ( 学号 nvarchar(10), 课程 nvarchar(10), 成绩 int ) go insert into Score values('0001','语文',87); insert into Score values('0001','数学',79); insert into Score val...