OPEN

---

Remarks

The OPEN (cursor) statement opens a cursor. A cursor must be defined before it can be opened.

This statement is allowed only inside of a stored procedure or a trigger, since cursors and variables are only allowed inside of stored procedures and triggers.

Examples

The following example opens the declared cursor BTUCursor.

DECLARE BTUCursor CURSOR 
FOR SELECT Degree, Residency, Cost_Per_Credit 
FROM Tuition 
ORDER BY ID; 

OPEN BTUCursor; 

See Also

CREATE PROCEDURE

CREATE TRIGGER

DECLARE CURSOR