select * from sys.tables
select * from question
declare question_cu --创建一个游标
cursor for
select * from question
open question_cu--打开游标
fetch next from question_cu--读取下一行
while @@fetch_status=0--如果状态为0
begin
fetch next from question_cu--继续读取
end
CLOSE question_cu--关闭游标
DEALLOCATE question_cu--彻底删除游标