cursor and rowcount

• scranthdaddy

  SSC-Addicted

  Points: 492

  More actions

  August 5, 2003 at 12:25 pm

  #84103

  I have a cursor declared that I would like to limit. I would like to have it return only 13 rows. I tried using set rowcount before and after the DECLARE selects the rows in, but it doesn't work. Anyone know a good way to do this?

  Thanks.

  Andrew J. Hahn

  
  Andrew J. Hahn

• tran008

  Ten Centuries

  Points: 1002

  More actions

  August 5, 2003 at 1:40 pm

  #468718

  SET ROWCOUNT 13

  GO

  select * from table

  GO

• winash

  SSChampion

  Points: 11446

  More actions

  August 5, 2003 at 2:48 pm

  #468729

  you could use TOP in the select statement of your cursor...

  DECLARE CursorName CURSOR FOR

  Select Top 13 ......