结构推理 编写T-SQL程序,使用游标将Student数据库的Teachers表的所有数据逐一取出。
【正确答案】USE Student
   GO
   DECLARE Teacher_cur SCROLL CURSOR
   FOR SELECT*FROM Teachers
   OPEN Teacher cur
   FETCH NEXT FROM Teacher cur
   WHILE@@FETCH_STATUS=0
   FETCH NEXT FROM Teacher_cur
   CLOSE Teacher_cur
   DEALLOCATE Teacher_cur
   GO
【答案解析】