open

Description

Opens a cursor for processing.

Syntax

open cursor_name

Parameters

cursor_name

is the name of the cursor to open.

Examples

Example 1

Opens the cursor named authors_crsr:

open authors_crsr

Usage

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

open permission defaults to all users.

See also

Commands close, declare cursor, fetch