SQL Server Cursor Types - Forward Only Static Cursor | SQL Server Tutorial

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

Forward Only Cursors do not allow backward scrolling. The only scrolling option we have is FETCH NEXT.

Forward only Static Cursors are not sensitive to any changes ( update, delete, insert) made to original data source after the cursor is created.

Blog post link for the video with scripts