--为一个查询语句建立游标
DECLARE cursorMeetingAttendee CURSOR FOR
select AttendantID from MAttPerson where MeetId = @MeetingId order by mid
--打开,遍历游标
OPEN cursorMeetingAttendee
--取出游标中的值
FETCH NEXT FROM cursorMeetingAttendee into @AttendeeId
--如果取出成功(没有到末尾)
WHILE @@FETCH_STATUS = 0
BEGIN
--
--使用游标取出的ID操作
--
--取下一条记录
FETCH NEXT FROM cursorMeetingAttendee into @AttendeeId
END
--关闭游标
CLOSE cursorMeetingAttendee
--销毁
DEALLOCATE cursorMeetingAttendee
DECLARE cursorMeetingAttendee CURSOR FOR
select AttendantID from MAttPerson where MeetId = @MeetingId order by mid
--打开,遍历游标
OPEN cursorMeetingAttendee
--取出游标中的值
FETCH NEXT FROM cursorMeetingAttendee into @AttendeeId
--如果取出成功(没有到末尾)
WHILE @@FETCH_STATUS = 0
BEGIN
--
--使用游标取出的ID操作
--
--取下一条记录
FETCH NEXT FROM cursorMeetingAttendee into @AttendeeId
END
--关闭游标
CLOSE cursorMeetingAttendee
--销毁
DEALLOCATE cursorMeetingAttendee