游标循环查询结果（sql server）

begin
DECLARE @CardNO nvarchar (100) ;
declare c_test_main cursor fast_forward for SELECT CardNO FROM Student WHERE SchoolId = '1603483F-E94F-49B1-93BB-1FCF88313BBC' ;
open c_test_main;--打开游标
while 1=1 --开始循环
begin
fetch next from c_test_main into @CardNO --赋值到变量中
if(@@fetch_status!=0)break;--如果没有结果退出循环

INSERT StudentDormitory (
ID,
LastActiveTime,
CardNo,
Stated,
IsDeleted,
Type,
CreateTime
)
VALUES
(
newid(),
getdate() ,@CardNO,
0,
0,
1,
getdate()
) ;
end
close c_test_main --关闭游标
deallocate c_test_main --释放游标
end