Dynamic Cursor
What is dynamic cursor in sql?and in which conditions we use it?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Satyapriya NayakPosted Sep 17, 2012, 1:20 AM
Please refer the below links
http://msdn.microsoft.com/en-us/library/ms189099%28v=sql.105%29.aspx
http://www.dotnet-tricks.com/Tutorial/sqlserver/RLID060512-SQL-Server-Different-Types-of-Cursors.html
Thanks
If this post helps you mark it as answer
Rajeev KumarPosted Feb 27, 2023, 7:21 AM
The SQL Dynamic Cursors are exactly opposite to Static Cursors. You can use this SQL Server Dynamic cursor to perform INSERT, DELETE, and UPDATE operations. Unlike static cursors, all the changes made in the Dynamic cursor will reflect the Original data.
Deepak MiddhaPosted Sep 17, 2012, 5:04 AM
Akkiraju IvaturiPosted Sep 16, 2012, 11:55 PM
Static cursors are the cursors that store complete resultset in tempdb when the cursor is opened. But, it will not fetch the results that are inserted after the cursor is opened. Dynamic cursors gets all the changes by scrolling the data one by one so that any new inserted data still be fetched by the dynamic cursor.