FORWARD_ONLY Cursor in SQL Server

FORWARD_ONLY Cursor in SQL Server 8

The FORWARD_ONLY Cursor in SQL Server does not support scrolling. This SQL FORWARD_ONLY cursor can only move from the first row to last and does not support the other way (scrolling backward). It means the SQL FORWARD_ONLY Cursors support the FETCH_ONLY option, and it will return an error for all the remaining FETCH options. SQL … Read more

Dynamic Cursor in SQL Server

Dynamic Cursor in SQL Server 2

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. Let us see how to Create a Dynamic Cursor in SQL Server, and how to … Read more

Static Cursor in SQL Server

Static Cursor in SQL Server 7

The SQL Static Cursors are always read-only because the result set will store in tempdb. You can use this static cursor in SQL Server to move both forward and backward. For this SQL Server Static Cursor demonstration, we use the below-shown table, which holds 14 records Static Cursor in SQL Server Example In this SQL … Read more