數(shù)據(jù)庫(kù)實(shí)驗(yàn)六實(shí)驗(yàn)報(bào)告-文庫(kù)吧資料
2025-08-10 10:19本頁(yè)面
【正文】 g_grade decimal(4,1) outputasselect avg_grade=AVG(grade)from scwhere o=oselect *from scdeclare avg decimal(4,1)exec course_average 39。 建帶輸出參數(shù)的存儲(chǔ)過程（1）創(chuàng)建一個(gè)名為coursce_averagede 的存儲(chǔ)過程，可查詢某門課程考試的平均成績(jī)。,39。gocreate procedure student_scsno1 nchar(8),sno2 nchar(8)asselect ,sname,sum(grade)總成績(jī)from student,sc,coursewhere = and = and =sno1 and =sno2group by ,sname execute student_sc 39。 drop procedure student_sc endelseprint 39。) begin print 39。and type=39。執(zhí)行if exists (select name from sysobjects where name=39。張虹39。計(jì)算機(jī)系39。as select ,sname,DATEDIFF (year,birth,getdate())as age,ame,grade from student ,sc ,course where student .sno= and =course .o and sdept like depart and sname like name exec stu_proc1。,name varchar(8)=39。執(zhí)行語(yǔ)句為：create procedure stu_proc1 depart char(20)=39。系名和姓名在調(diào)用該存儲(chǔ)時(shí)輸入，其默認(rèn)值分別為“%”與“林%”。TSQL創(chuàng)建存儲(chǔ)過程的基本語(yǔ)法格式：CREAT
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1