Monday, March 10, 2008

what is a cursor ? whay do you need cursor.

Cursor is a symbolic name that is associated with t-sql select statement through a declarative statement it consist of following parts.
• Cursor result set-a set of row resulting from the excecution of a query assosicated with the cursor.
• Cursor position –pointer to one row within the cursor result set.
• Cursor can be used to access data row by row.

No comments: