DYNAMIC CURSOR & FORWARD_ONLY CURSOR - SQL Server
DYNAMIC CURSOR
In dynamic cursor you can see any kind of changes happening i.e. either inserting new records or changes in the existing and even deletes in the BASE TABLE - How ?
Means i want to know : Does it points to BASE TABLE directly in the same database instead of tempdb or while fetching the data it will re-evaluate the cursor ? etc... Just want to know internally what is happening !
FORWARD_ONLY CURSOR
In forward_only cursor also you can see any kind of changes happening i.e. either inserting new records or changes in the existing and even deletes until you have specified "STATIC" or "KEYSET" - How ? Just want to know internally what is happening !
Please do NOT provide MSDN !!
Thanks
In dynamic cursor you can see any kind of changes happening i.e. either inserting new records or changes in the existing and even deletes in the BASE TABLE - How ?
Means i want to know : Does it points to BASE TABLE directly in the same database instead of tempdb or while fetching the data it will re-evaluate the cursor ? etc... Just want to know internally what is happening !
FORWARD_ONLY CURSOR
In forward_only cursor also you can see any kind of changes happening i.e. either inserting new records or changes in the existing and even deletes until you have specified "STATIC" or "KEYSET" - How ? Just want to know internally what is happening !
Please do NOT provide MSDN !!
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
... even though it already processed that row as 'KAy' ... --should be 'Kay', NOT 'Key'