SQL Server Cursor Types - Static Cursor | SQL Server Tutorial

Published: 06 April 2015
on channel: TechBrothersIT

5,634

Cursors are the objects those allow us to access the data row by row from result set.

Static Cursor make the copy of result set in memory at time of cursor creation and use that temporary result set to return rows. If any changes are made to original table/s data such as insert, update or delete. The Static cursor does not update stored result set with those changes unless we close the cursor and reopen.

Static Cursors are scrollable (First,Last,Prior,Next,Relative,Absolute)

Blog post link for this video with scripts
http://sqlage.blogspot.com/2015/04/sq...

On this page of the site you can watch the video online SQL Server Cursor Types - Static Cursor | SQL Server Tutorial with a duration of hours minute second in good quality, which was uploaded by the user TechBrothersIT 06 April 2015, share the link with friends and acquaintances, this video has already been watched 5,634 times on youtube and it was liked by 23 viewers. Enjoy your viewing!

262