无标题1.sql

一般的数据库系统

exec sp_addtype 'student_num','char(9)','not null'
select xs.xh,xm,grade=case
  when cj>=85 then '优秀'
  when cj>=75 then '良好'
  when cj>=60 then '合格'
 else  '不合格'
 end
from xs,xs_kc,kc
where xs.xh=xs_kc.xh and xs_kc.kch=kc.kch
declare @n int,@t int
set @n=2
 while @n<=1000
   begin 
     set @t=2
          while @t<@n
              begin 
                 if @n%@t=0
                 break 
                 set @t=@t+1
end 
  if @t>=@n
    print @n
    set @n=@n+1
  end
select dbo.average('计算机基础') as 平均分

DECLARE @AVER INT 
EXECUTE @AVER=dbo.average'计算机基础' 
SELECT @AVER