Examples Using "WHERE CURRENT OF"

• YCH

  SSC Eights!

  Points: 892

  More actions

  August 26, 2003 at 8:42 am

  #81672

  I open a cursor and loop through the records. I wanted to update one record that I am fetching. I checked the BOL and read about the "WHERE CURRENT OF" clause but had not had much success with it.

  Did anyone use this before? I appreciate your sharing with me some examples.

• NPeeters

  SSChampion

  Points: 12584

  More actions

  August 26, 2003 at 9:07 am

  #471439

  Declare your cursor as follows

  
  
  USE PUBS
  
  DECLARE @lName varchar(40)
  
  
  
  DECLARE crsMyCursor CURSOR FOR
  
     SELECT au_lname FROM AUTHORS
  
  
  
  OPEN crsMyCursor
  
  
  
  FETCH NEXT FROM crsMyCursor INTO @lName
  
  
  
  UPDATE Authors SET au_lname = 'Hello World' WHERE CURRENT OF crsMyCursor
  
  
  
  CLOSE crsMyCursor
  
  DEALLOCATE crsMyCursor
  
  

• YCH

  SSC Eights!

  Points: 892

  More actions

  August 26, 2003 at 9:44 am

  #471450

  THANK YOU!