Best practice for testing @@FETCH_STATUS for a cursor

• barry555

  SSC Eights!

  Points: 944

  More actions

  March 14, 2006 at 10:26 am

  #112037

  BOL (2005) gives cursor examples which test @@FETCH_STATUS in different ways.  I wondered if there is any difference/best practice.

  The 3 examples are:

  WHILE (@@FETCH_STATUS <> -1)

  BEGIN

     IF (@@FETCH_STATUS <> -2)

  WHILE @@FETCH_STATUS = 0

  WHILE (@@FETCH_STATUS <> -1)

  Thanks,

  Barry

• Jo Pattyn

  SSC-Dedicated

  Points: 32347

  More actions

  March 14, 2006 at 12:53 pm

  #626628

  I only needed WHILE @@FETCH_STATUS = 0

  Checking for other conditions would complicate my code.

  *

  0	FETCH statement was successful.
  -1	FETCH statement failed or the row was beyond the result set.
  -2	Row fetched is missing.