title: Get Multiple Values in SQL Server Cursor
body: <p>I have a cursor containing several columns from the row it brings back that I would like to process at once.  I notice most of the examples I've seeing on how to use cursors show them assigning a particular column from the cursor to a scalar value one at a time, then moving to the next row, </p>
  
  <p>e.g.</p>
  
  <pre><code>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
  </code></pre>
  
  <p>What I want to know is if it's possible to do something like the following:</p>
  
  <pre><code>    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
  </code></pre>
  
  <p>Help is always appreciated.</p>