数据库原理实验游标与存储过程.docVIP

建立EPoem表和CPoem表，并插入数据 EPoem CPoem 写存储过程read_poem，依次实现如下功能 显示 “英文诗” 依次显示EPoem的所有记录 显示一个空行 显示“中文诗” 依次显示CPoem的所有记录 代码： create table czk_EPoem ( LineText char(1000) not null ) create table czk_CPoem ( LineText char(100) not null ) insert into czk_EPoem values(The furthest distance in the world, is not between life and death) insert into czk_EPoem values(But when I stand in front of you, yet you don’t know that I love you) insert into czk_EPoem values(The furthest distance in the world, is not when I stand in front of you, yet you can’t see my love) insert into czk_EPoem values(But when undoubtedly knowing the love from both, yet cannot be together) insert into czk_EPoem values(The furthest distance in the world, is not being apart while being in love) insert into czk_EPoem values(But when plainly can not resist the yearning, yet pretending you have never been in my heart) insert into czk_EPoem values(The furthest distance in the world, is not when plainly cannot resist the yearning, yet pretending you have never been in my heart) insert into czk_EPoem values(But using one’s indifferent heart, to dig an uncrossable river for the one who loves you) select * from czk_EPoem insert into czk_CPoem values(世界上最遥远的距离，不是生与死) insert into czk_CPoem values(而是我就站在你的面前，你却不知道我爱你 ) insert into czk_CPoem values(世界上最遥远的距离，不是我站在你面前，你却不知道我爱你 ) insert into czk_CPoem values(而是明明知道彼此相爱，却不能在一起 ) insert into czk_CPoem values(世界上最遥远的距离，不是明明知道彼此相爱，却不能在一起 ) insert into czk_CPoem values(而是明明无法抵挡这股思念，却还得故意装作丝毫没有把你放在心里 ) insert into czk_CPoem values(世界上最遥远的距离，不是明明无法抵挡这股思念，却还要故意装作丝毫没有把你放在心里， ) insert into czk_CPoem values(而是用自己冷漠的心，对爱你的人掘了一条无法跨越的沟渠 ) select * from czk_CPoem if exists(select name from sysobjects where name=read_poemand type=p) drop procedure read_poem go create procedure read_poem as declare @e char(500) declare readpe cursor local scroll for select * from czk_EPoem open readpe print 英文诗 fetch next from