Local vs global cursor

• win

  SSCommitted

  Points: 1569

  More actions

  July 9, 2004 at 2:24 am

  #108272

  Is there any other speed advantage in declaring a cursor as local to a procedure/trigger apart from not having to close and deallocate the cursor explicitely.  For example is a local cursor declared on a stack and the global cursor declared on a heap or similar memory structure. Any comments appreciated

  Cheers,

  Win

• July 12, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Nilssond

  Hall of Fame

  Points: 3285

  More actions

  July 12, 2004 at 11:11 am

  #514289

  see the following:

   

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_07_3w6r.asp

• win

  SSCommitted

  Points: 1569

  More actions

  July 12, 2004 at 6:36 pm

  #514316

  Thanks for the URL, interesting article, doesn't mention speed implications tho'.  Maybe there is no difference.

  Cheers,

  Win