【正文】
rsor For select distinct , from instructor,student,advisorwhere =39。Einstein39。 and = and =for read onlydeclare @id char(20),@name char(20),@dept_name char(20) ,@tot_cred char(20)open studentfetch next From student into @id ,@name,@dept_name ,@tot_credWHILE @@FETCH_STATUS = 0BEGINPRINT @id +@name+@dept_name+@tot_credfetch next From student into @id ,@name,@dept_name ,@tot_credENDclose studentDEALLOCATE student四、實(shí)驗(yàn)結(jié)果及分析和(或)源程序調(diào)試過程實(shí)驗(yàn)三:: 命令成功完成。命令成功完成。命令成功完成。命令成功完成。實(shí)驗(yàn)四:1.命令成功完成。