while @@fetch_status=0.sql

来自「在学习SQL Server过程中整理的T-SQL语句」· SQL 代码 · 共 14 行

use test
declare @name char(20),@st_id char(4)
declare student_cursor cursor for
                       select sno,sname from XS
open student_cursor
fetch next from student_cursor into @st_id,@name
select @st_id,@name
while @@fetch_status=0
     begin
         fetch next from student_cursor into @st_id,@name
          select @st_id,@name
     end
close student_cursor
deallocate student_cursor