-- 临时变量

DECLARE @Id UNIQUEIDENTIFIER

-- 声明游标名

DECLARE cursor_name CURSOR

FOR SELECT ID from COM_DataDictionaryInfo

-- 打开游标

OPEN cursor_name

-- 先查询一次再循环，防止有多个游标时@@FETCH_STATUS=-1不能进入下个游标循环的情况

FETCH NEXT FROM cursor_name into @Id

-- 循环取数据

WHILE @@FETCH_STATUS = 0

BEGIN

    SELECT @Id

    FETCH NEXT FROM cursor_name into @Id

END

-- 关闭游标

Close cursor_name

-- 删除游标

Deallocate cursor_name