DefaultCursor Property
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The DefaultCursor property controls the visibility of cursors created in Transact-SQL batches.
Syntax
object
.DefaultCursor [=value]
Parts
- object
An expression that evaluates to an object in the Applies To list
- value
TRUE or FALSE
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetDefaultCursor(LPBOOL pRetVal);
HRESULT SetDefaultCursor(BOOL NewValue);
Remarks
Microsoft SQL Server cursor scope can be local, meaning visible only within the scope of a batch, or global, meaning visible to any process within the scope of the session.
If TRUE, cursors declared in a batch are created with local scope.
If FALSE, cursors declared in a batch are created with global scope.
For more information, see DECLARE CURSOR (Transact-SQL).