sql_server_2000_實(shí)用教程習(xí)題答案葉潮流吳偉大連理工大學(xué)出版-wenkub.com
2025-06-16 14:50 本頁(yè)面
【正文】 ,39。,39。,39。else begin insert into 選修select * from inserted print 39。 select * from 選修 where 學(xué)號(hào)= stuidendreturngodelete from 學(xué)生 where 學(xué)號(hào)=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。 where 學(xué)號(hào)=stuid and 課程號(hào)=courseidgoinsert into 選修(學(xué)號(hào),課程號(hào),成績(jī))values(39。,39。,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。go或create proc pro_num_選修1 kch char(2)=39。asselect * from 班級(jí) where 班級(jí)號(hào)=bjbhgoexec class_infogo3．use jxglgocreate proc proc_numkch char(2)=39。 end習(xí)題九一、填空題 4. 5. output of 9. deleted 10. update二、選擇題 1115. DBBBC三、實(shí)踐題1.use jxglgocreate proc nacrissusasdeclare 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。 when 0 then 39。 else 39。 endopen mycursor3select cursor_rows, case cursor_rows when 1 then 39。 when 0 then 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。賈諸葛39。女39。0801010139。13010139。安徽39。安徽39。安徽39。19911139。男39。男39。男39。女39。安徽39。not null39。39。05512159[09][09][09]39。d:\stu\39。d:\stu\39。d:\stu\39。,size=5,maxsize=10,filegrowth=1)log on(name=lx_log,filename=39。),(name=dyb,filename=39。,size=1,maxsize=unlimited,filegrowth=1)go（3）alter database lx modify name=studbgo（4）習(xí)題五一、選擇題15. CDB
法律信息相關(guān)推薦
鄂ICP備17016276號(hào)-1