What is cursor? types? various operation?

Posted by mareesnectar-12158 under Sql Server on 12/20/2011 | Points: 10 | Views : 5048 | Status : [Member] | Replies : 6
HI........

Explain What is cursor?
what are the types and various operation with suitable esample?
what are the advantages?

Thanks and Regards
Mareeswaran




Responses

Posted by: Sksingh on: 12/20/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,

Refer http://msdn.microsoft.com/en-us/library/ms172375.aspx

Regards,
Sunil

mareesnectar-12158, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sksamantaray on: 12/20/2011 [Member] Silver | Points: 25

Up
0
Down
http://msdn.microsoft.com/en-us/library/ms180169.aspx
http://blog.sqlauthority.com/2007/01/01/sql-server-simple-example-of-cursor/
http://blog.sqlauthority.com/2008/03/05/sql-server-simple-example-of-cursor-sample-cursor-part-2/
http://www.mssqltips.com/tip1599_2.asp?tip=1599

The above links may help you

Thanks,
Sanjay

mareesnectar-12158, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: mareesnectar-12158 on: 12/20/2011 [Member] Starter | Points: 25

Up
0
Down
thanks


mareesnectar-12158, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: satender2008-12857 on: 12/21/2011 [Member] Starter | Points: 25

Up
0
Down
HEllo sunil sir,

How can i clear my basic funda's like
1. I don't know where i have to use interface ?
2. How can i remember for a long time because i forget funda's after some time.

please guide me how can i improve my programming

Regards,
Satender

mareesnectar-12158, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muhsinathk on: 6/22/2012 [Member] Bronze | Points: 25

Up
0
Down
Hi,
A cursor is a variable that runs through the tuples of some relation. This relation can be a stored table, or it can be the answer to some query.
There are different types of cursors but broadly classified into two :

Implicit cursor
Explicit cursor.
Every query that we issue on a database is an implicit cursor for eg. a select, an update, a delete etc.
On the otherhand explicit cursor is a user defined cursor eg: cursor explicit_cur as .....

mareesnectar-12158, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muhsinathk on: 6/22/2012 [Member] Bronze | Points: 25

Login to post response