Cursor In SQL Server

Posted by Lakhangarg under Sql Server on 8/18/2009 | Views : 4532 | Status : [Member] [Moderator] | Replies : 4
Should we use Cursor or we need to use any alternative like while loop and other queries instead of Cursor? How Cursor execute in the memory?




Responses

Posted by: perfectchourasia-9163 on: 6/8/2012 [Member] Starter | Points: 25

Up
0
Down
http://www.roseindia.net/sql/creating-cursors-sql.shtml

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://www.aspnetcodes.com/

Lakhangarg, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Raja on: 8/18/2009 [Member] Starter

Up
0
Down
We should avoid using Cursor in SQL Server and go for alternative approaches if possible.

To more about cursors, please go through

http://www.mssqltips.com/tip.asp?tip=1599
http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1176815,00.html

Thanks



Regards,
Raja, USA

Lakhangarg, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Lakhangarg on: 8/18/2009 [Member] [Moderator] Silver

Up
0
Down
Hi Raja-

What about the execution of cursor in memory.. can you please explain it in little bit more detail?

Thanks & Regards
Lakhan Pal Garg

Lakhangarg, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Raja on: 8/18/2009 [Member] Starter

Up
0
Down
Please go through this article that has detailed explanations of Cursor in SQL Server.

http://www.mssqlcity.com/Articles/General/UseCursor.htm

Hope this helps.

Regards,
Raja, USA

Lakhangarg, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response