Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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.


object
.DefaultCursor [=value]
object

An expression that evaluates to an object in the Applies To list

value

TRUE or FALSE

Boolean

Read/write

HRESULT GetDefaultCursor(LPBOOL pRetVal);
HRESULT SetDefaultCursor(BOOL NewValue);

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).

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.