ACCP7.0S2优化MySchool数据库设计第三章上机1-3

--上机1
declare @name nvarchar(255)
set @name='★'
declare @int int
set @int=1
while(@int<6)
begin
print @name
set @name+='★'
set @int+=1
end
go




--上机2
select studentno as '学号',StudentName as '姓名',FLOOR(DATEDIFF(dy,birthday,getdate())/365) as '年龄' from dbo.Student where studentno='23225'
declare @yy int
select @yy=DATEPART(YY,birthday) from student where studentno='23225'
select * from student where DATEPART(YY,birthday)=@yy+1 or DATEPART(YY,birthday)=@yy-1
go




--上机3
select top 1 studentname,studentresult from student,result,subject where student.studentno='23219' and subject.subjectid=2
declare @result int
select @result=studentresult from student,result,subject where student.studentno='23219' and subject.subjectid=2
if(@result>85)
print '优秀'
else if(@result>70)
print '良好'
else if(@result>60)
print '中等'
else
print '差'