What is cursor? types? various operation?

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

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

thanks

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

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

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

Hi,

Please refer this link too..

http://msdn.microsoft.com/en-us/library/ms378405(v=sql.90).aspx
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.apdv.plsql.doc%2Fdoc%2Fc0053893.html

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