SQL Server Cursor Types - Dynamic Cursors | SQL Server Tutorial
Cursors are the objects those allow us to access the data row by row from result set.
Dynamic Cursors are update-able. The dynamic cursor will fetch the changes (insert,update or delete) on each fetch while cursor is open if any modification happened to original data in table/s. This type of Cursor is helpful when we want to extract the records from original table/s while cursor is open and we are still in process of modification of data or inserting new records and want to include them in cursor result set to perform operation.
Dynamic cursors are scrollable (First,Last,Prior,Next,Relative) but absolute option does not work with dynamic Cursors.
Blog post link for the video with scripts
http://sqlage.blogspot.com/2015/04/sq...
En esta página del sitio puede ver el video en línea SQL Server Cursor Types - Dynamic Cursors | SQL Server Tutorial de Duración hora minuto segunda en buena calidad , que subió el usuario TechBrothersIT 06 abril 2015, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 11,385 veces y le gustó 30 a los espectadores. Disfruta viendo!
