In a static cursor, neither the cursor owner nor any other user can change the result set while the cursor is open. Values, membership, and order remain fixed until the cursor is closed. You can either take a snapshot of the result set (which begins to diverge from the snapshot as updates are made), or you can lock the entire result set to prevent updates.
It is not necessary for cursor routines to support static cursors directly. You can achieve static behavior through one of the following methods:
Take a snapshot copy of the result set (with select...into), and then call dbcursoropen against the snapshot (temporary table).
Lock the result set by calling dbcursoropen with the holdlock keyword in a select statement. However, this method significantly reduces concurrency.
