Passing Parameter to a cursor

• anupgupta

  Grasshopper

  Points: 17

  More actions

  July 7, 2002 at 8:04 pm

  #105538

  Hi All,

  Is it possible to pass parameters to a cursor in t- sql, as we can do in PL/SQL?

  I need to write a parameterized cursor in a stored procedure. Please help me out with it.

• runelords

  Ten Centuries

  Points: 1275

  More actions

  February 28, 2005 at 3:22 pm

  #544504

  Any help on this at all. I have the same question.

  
  Arthur Lorenzini

• schleep

  SSChampion

  Points: 12587

  More actions

  March 1, 2005 at 8:46 am

  #544623

  The parm is to limit the cursor rows?

  DECLARE mycursor CURSOR FOR

  SELECT cols

  FROM mytable

  WHERE col1 = @myparm

  OPEN mycursor.....