结构推理
编写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
【答案解析】
提交答案
关闭