SQL Server Performance

Cursors in 2005

Discussion in 'SQL Server 2005 General Developer Questions' started by johalljr99, Oct 27, 2006.

  1. johalljr99 New Member

    <font face="Comic Sans MS">Has anyone experienced problems using cursors in SQL 2005. The initial talk was cursors would not be compatible in 2005. Is this still true?</font id="Comic Sans MS"><br /><br />Joe<img src='/community/emoticons/emotion-1.gif' alt=':)' />
  2. mmarovic Active Member

    Really? Cursors are part of the ansi standard.
  3. joechang New Member

    i think they meant the API Server cursors,
    which are calls to SQL like sp_cursoropen etc

    i think the decision was to support in some kind of mode, possibly not performing as well
    i think it is mentioned in some of the S2K5 blogs on the MS site
  4. mmarovic Active Member

    Thanks, Joe.
  5. Madhivanan Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by johalljr99</i><br /><br /><font face="Comic Sans MS">Has anyone experienced problems using cursors in SQL 2005. The initial talk was cursors would not be compatible in 2005. Is this still true?</font id="Comic Sans MS"><br /><br />Joe<img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Where did you read this?<br />Note that except few cases you dont need Cursor<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail

Share This Page