SQL sever 游标简单使用

DECLARE @tablename varchar(20),@id_name varchar(100)
declare count_cursor cursor  --声明游标名
for
	select * FROM Table_key  --需要读取的结果集
for read only
	open count_cursor        --打开游标
	FETCH NEXT FROM count_cursor INTO @tablename,@id_name --抓取下一行游标数据
WHILE @@FETCH_STATUS = 0
  BEGIN
    PRINT '表名：'+@tablename+'      '+'主键：'+@id_name
	 
  END
CLOSE count_cursor --关闭游标
DEALLOCATE count_cursor --释放游标

https://blog.csdn.net/RemyRan/article/details/85052964
上面游标会出现死循环执行特别慢，更改如下，方法如上面链接：

DECLARE @tablename varchar(20),@id_name varchar(100)
declare count_cursor cursor
for
	select * FROM Table_key
for read only
	open count_cursor
	FETCH NEXT FROM count_cursor INTO @tablename,@id_name --抓取下一行游标数据
WHILE @@FETCH_STATUS = 0
  BEGIN

    PRINT '表名：'+@tablename+'      '+'主键：'+@id_name
	 FETCH NEXT FROM count_cursor INTO @tablename,@id_name
  END
CLOSE count_cursor --关闭游标
DEALLOCATE count_cursor --释放游标