數(shù)據(jù)庫課程設(shè)計(jì)--學(xué)生成績管理系統(tǒng)-在線瀏覽
2025-03-07 15:47本頁面
【正文】 insert into sc(sno,o,grade) values(ssno,o,grade) End執(zhí)行存儲(chǔ)過程：exec sc_insert 39。,39。,89建立一個(gè)存儲(chǔ)過程，該存儲(chǔ)過程實(shí)現(xiàn)在sc表刪除數(shù)據(jù)create procedure sc_delete ssno char(6) as begin DELEte sc WHERE = ssno End執(zhí)行存儲(chǔ)過程：exec sc_delete 39。建立一個(gè)存儲(chǔ)過程，該存儲(chǔ)過程實(shí)現(xiàn)在student表插入功能：create procedure s_insert ssno char(6),sname char(20),ssex char(2),sage smallint,sclno char(4) as begin insert into Student (sno,sname,ssex,sage,sclno ) values(ssno,sname,ssex ,sage,sclno) End執(zhí)行存儲(chǔ)過程： exec s_insert 39。,39。,39。,19,39。建立一個(gè)存儲(chǔ)過程，該存儲(chǔ)過程實(shí)現(xiàn)在student表刪除功能： create procedure s_delete ssno char(6) as begin DELEte Student WHERE = ssno End執(zhí)行存儲(chǔ)過程： exec s_delete 39。建立一個(gè)存儲(chǔ)過程，該存儲(chǔ)過程實(shí)現(xiàn)在course表插入功能： create procedure c_insert o char(4),ame char(10),cpno char(10), ctno char(6),ccredit int as begin Insertint ocourse(o,ame,cpno,ctno,ccredit) values(o,ame ,cpno,ctno,ccredit) end建立一個(gè)存儲(chǔ)過程，該存儲(chǔ)過程實(shí)現(xiàn)在course表刪除功能：create procedure c_delete o char(4) as begin
法律信息相關(guān)推薦
鄂ICP備17016276號(hào)-1