第三章：SQL 编程

--上机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 '差'