1、1. (1) declare a int,b int declare c float declare s1 char(3),s2 char(3)set a=5set b=4set c=4.0set s1=abcset s2=defselect a*b asa与b的积, a/b asa与b的商, a%b asa与b的余数, a&b as 按位与, a|b as 按位或, ab as 按位异或, a/c asa与c的商, s1+s2 ass1与s2的连串(2)select version(3)use stuinfodeclare x char(8)select x=sname from stude
2、ntwhere sno=105select x(4)use stuinfodeclare y int,z intselect y=COUNT(*),z=max(degree)from scorewhere cno=3-105select y as选课人数,z as最高成绩2.(1)use stuinfoselect sname姓名,cno 课程名,casewhen degree=90 then优when degree=80 then良when degree=70 then中when degree=60 then及格when degree1.3print 男生比女生成绩高多了if c=0.8pr
3、int 男生与女生成绩差不多if c0.8print 女生比男生成绩高多了(3)use stuinfocreate table xsrq (spno char(4) default(3741), spname char(20) default(苹果MacBook Pro ), scrq date, sl int)use stuinfodeclare m intset m=0while m20 begin set m=m+1 insert into xsrq(scrq) values (dateadd(DAY,m,getdate() end3. (1)use stuinfogocreate fu
4、nction average(cn char(4)returns floatasbegindeclare aver floatselect aver=(select avg(degree)from score where cno=cn)return averendgodeclare coursel char(6)set coursel=3-105select dbo.average(coursel) as 3-105号课程的平均成绩go(2)use stuinfogocreate function cj(no char(5)returns tableasreturn (select sname,cno,degree from student,scorewhere student.sno=no and student.sno=score.sno)goselect*from cj(103)update cj(103) set degree=100where cno=3-105(3)
