sql_server_2000_實用教程習(xí)題答案葉潮流吳偉大連理工大學(xué)出版(編輯修改稿)
2024-07-16 14:50 本頁面
【文章內(nèi)容簡介】 om 選修 where 成績(select avg(成績) from 選修)略習(xí)題七一、填空題 8. max()9. waitfor 11. sysments 12. ‘a(chǎn)b’ 13. 當(dāng)前系統(tǒng)日期時間的字符 14. TSQL 15. GO 16. 批處理17. Unicode 18. 內(nèi)嵌表值 19. smalldatetime 20. smallmoney二、選擇題15DCBDA 610DCDBD 1115 ACBDB 1620. BDBAB 2125 DCCBC三、實踐題1．declare @a int,@b int,@c floatset @a =10set @b=20set @c=@a*@bprint @c2．declare @i tinyint,@j tinyintset @i=1while @i=4begin set @j=2*@i1 print space(202*@i)+ replicate(39。* 39。,@j) set @i=@i+1end3.create function (@gh char(8)=39。13010139。)returns table as return(select ,姓名,性別,課程號,班級號 from 教師,授課where = and =@gh)go select * from (default)go4.create function (@num1 int,@num2 int)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=(@n@I*100)/10 set @k=@n%10 if @n=@i*@i*@i+@j*@j*@j+@k*@k*@k print cast(@n as char(3))+39。是水仙花數(shù)39。 set @n=@n+1 endgo6.create function score_info(@xh char(8))returns @total_score table (學(xué)號 char(8),姓名 char(6),性別 char(2),課程號 char(2),課程名稱 varchar(20),成績 numeric(5,1))asbegininsert @total_scoreselect ,姓名,性別,課程名稱,from 學(xué)生,課程,選修where = and = and =@xhreturn end go select * from score_info(39。0801010139。)習(xí)題八一、填空題 4. scroll 5. fetch check option 9. 查詢 10. 更新二、選擇題 三、實踐題1.use jxglgocreate view informasselect 學(xué)號,姓名,性別,39。入學(xué)成績39。=總分from 學(xué)生where 性別=39。女39。go2.select * from inform3.use jxglgocreate view Inform asselect * from 學(xué)生go insert into Inform (學(xué)號,姓名,性別) values (39。0801020339。,39。賈諸葛39。,39。女39。)運行結(jié)果：兩者都有數(shù)據(jù)，因為通過視圖插入是直接對表的操作。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 my
法律信息相關(guān)推薦
鄂ICP備17016276號-1