我有一个游标,其中包含它返回的行中的几列,我想立即处理这些列.我注意到,我看到的关于如何使用游标的大多数示例显示,它们将游标中的特定列一次分配给一个标量值,然后移动到下一行,
例如
OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @name
WHILE @@FETCH_STATUS = 0
BEGIN
--Do Stuff with @name scalar value, then get next row from cursor
FETCH NEXT FROM db_cursor INTO @name
END
我想知道的是,是否有可能做到以下几点:
OPEN db_cursor
FETCH NEXT FROM db_cursor;
WHILE @@FETCH_STATUS = 0
BEGIN
SET @myName = db_cursor.name;
SET @myAge = db_cursor.age;
SET @myFavoriteColor = db_cursor.favoriteColor;
--Do stuff with scalar values
FETCH NEXT FROM db_cursor;
END
帮助总是值得感激的.