sql_server_2000_實用教程習題答案葉潮流吳偉大連理工大學出版-文庫吧在線文庫
【正文】 39。女39。男39。19911139。安徽39。13010139。女39。Select * from 學生 和 Select * from Inform4.use jxgldeclare mycursor scroll cursor for select * from 學生open mycursorfetch first from mycursorfetch last from mycursor5.（1）use jxgldeclare mycursor2 insensitive cursorfor select * from 學生open mycursor2 select cursor_rows, case cursor_rows when 1 then 39。 when 0 then 39。 else 39。 end習題九一、填空題 4. 5. output of 9. deleted 10. update二、選擇題 1115. DBBBC三、實踐題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。go或create proc pro_num_選修1 kch char(2)=39。,39。 where 學號=stuid and 課程號=courseidgoinsert into 選修(學號,課程號,成績)values(39。 select * from 選修 where 學號= stuidendreturngodelete from 學生 where 學號=39。,39。,39。,39。else begin insert into 選修select * from inserted print 39。,56)goselect * from 選修go6.use jxglgoalter trigger tri_del_學生 on 學生 for delete asdeclare stuid char(8) select stuid=學號 from deleted if (select count(*) from deleted /* where 學號= stuid*/)rowcountprint 39。,39。4.use jxglgo create trigger ins_學生on 學生after insertasdeclare age intselect age=datediff(yy,getdate()) from 學生,inserted where =if age10 begin raiserror(39。asselect * from 班級 where 班級號=bjbhgoexec class_infogo3．use jxglgocreate proc proc_numkch char(2)=39。 when 0 then 39。 endopen mycursor3select cursor_rows, case cursor_rows when 1 then 39。 else 39。賈諸葛39。0801010139。安徽39。安徽39。男39。男39。安徽39。39。d:\stu\39。d:\stu\39。),(name=dyb,filename=39。Go（9）exec sp_bindrule 39。習題六一、選擇題15. CCBAB 1620. BCCCA 2125ADDCC 2630 CDCBC二、填空題 3.[] by by by 12. where 13. 相關(guān)子查詢 14. 交叉連接 15. all 16. with rollup 17. distinct18. from子句 19.
法律信息相關(guān)推薦
鄂ICP備17016276號-1