-- priklad deklarace a pouziti cursoru
-- umoznuje v cyklu prochazet radky reordsetu
-- 11/2015 R. Danel

declare @surname varchar(50)
declare @name varchar(50)
declare @subject varchar(50)
declare @exam_result tinyint
declare @exam_result_points smallint
declare @exam_date datetime

declare EXAM_RESULT_CUR cursor FORWARD_ONLY for
    select STUDENT_NAME, SURNAME, EXAM_DATE, SUBJECT_NAME, EXAM_RESULT_POINTS, EXAM_RESULT
   from STUDENT, RESULT, SUBJECTS
     where STUDENT.ID_STUDENT = RESULT.ID_STUDENT
              and
           SUBJECTS.ID_SUBJECT = RESULT.ID_SUBJECT
                    for READ ONLY

open EXAM_RESULT_CUR 

fetch from EXAM_RESULT_CUR into @name, @surname, @exam_date, @subject, @exam_result_points, @exam_result

while (@@fetch_status = 0)
begin
	select @name, @surname, @exam_date, @subject, @exam_result_points, @exam_result
	
   	fetch next from EXAM_RESULT_CUR into @name, @surname, @exam_date, @subject, @exam_result_points, @exam_result
end


close EXAM_RESULT_CUR 
deallocate EXAM_RESULT_CUR