SQL Server Performance Forum – Threads Archive
Cursors in 2005
<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=’
‘ />
Really? Cursors are part of the ansi standard.
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
Thanks, Joe.
<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
]]>