DefaultCursor Property (SQL-DMO)

The DefaultCursor property controls the visibility of cursors created in Transact-SQL batches.

Applies To

Syntax

object.DefaultCursor [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	True or False

Remarks

Microsoft® SQL Server™ cursor scope may 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.

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetDefaultCursor(LPBOOL pRetVal);

HRESULT SetDefaultCursor(BOOL NewValue);