题库更新.txt

一套在线考试系统

update T_Question 
  set Department = (case len(subject) when 4 then substring(subject,3,2)+'部' else subject+'部' end) 
 from  T_Question