【正文】 nt)returns intasbegindeclare max intset max=case when num1=num2 then num1 when num1=num2 then num2 endreturn maxend5．declare n int,i int,j int,k int set n=100while n=999 begin set i=n/100 set j=(nI*100)/10 set k=n%10 if n=i*i*i+j*j*j+k*k*k print cast(n as char(3))+39。11.select top 5 * into course from 課程12.select 籍貫,count(*) from 學(xué)生 group by 籍貫13.select 學(xué)號(hào),姓名,籍貫 from 學(xué)生 where 籍貫=39。)goselect * from 學(xué)生 where 性別=39。Go（9）exec sp_bindrule 39。d:\stu\39。39。男39。安徽39。0801010139。 else 39。 when 0 then 39。4.use jxglgo create trigger ins_學(xué)生on 學(xué)生after insertasdeclare age intselect age=datediff(yy,getdate()) from 學(xué)生,inserted where =if age10 begin raiserror(39。,56)goselect * from 選修go6.use jxglgoalter trigger tri_del_學(xué)生 on 學(xué)生 for delete asdeclare stuid char(8) select stuid=學(xué)號(hào) from deleted if (select count(*) from deleted /* where 學(xué)號(hào)= stuid*/)rowcountprint 39。,39。,39。 where 學(xué)號(hào)=stuid and 課程號(hào)=courseidgoinsert into 選修(學(xué)號(hào),課程號(hào),成績(jī))values(39。go或create proc pro_num_選修1 kch char(2)=39。 else 39。Select * from 學(xué)生 和 Select * from Inform4.use jxgldeclare mycursor scroll cursor for select * from 學(xué)生open mycursorfetch first from mycursorfetch last from mycursor5.（1）use jxgldeclare mycursor2 insensitive cursorfor select * from 學(xué)生open mycursor2 select cursor_rows, case cursor_rows when 1 then 39。13010139。19911139。女39。05512159[09][09][09]39。,size=5,maxsize=10,filegrowth=1)log on(name=lx_log,filename=39。go(10)exec sp_addtype 編號(hào),39。)7.select* from 學(xué)生 order by 總分desc8.select ,姓名,性別,課程號(hào),成績(jī) from 學(xué)生,選修where = and 成績(jī)859.select 姓名,39。goselect,count(*) from 學(xué)生where 籍貫=39。)習(xí)題八一、填空題 4. scroll 5. fetch check option 9. 查詢 10. 更新二、選擇題 三、實(shí)踐題1.use jxglgocreate view informasselect 學(xué)號(hào),姓名,性別,39。非動(dòng)態(tài)游標(biāo),包含總行數(shù)39。沒有打開游標(biāo)39。不能輸入年齡小于10的學(xué)生39。刪除了選修表數(shù)據(jù)，有影響39。stu_login2