Export (0) Print
Expand All
ABS
ALL
AND
ANY
AVG
bit
COS
COT
DAY
EXP
GO
IN
LEN
LOG
MAX
MIN
NOT
OR
PI
SET
SIN
STR
SUM
TAN
USE
VAR
Expand Minimize
4 out of 5 rated this helpful - Rate this topic

CLOSE

SQL Server 2000

Closes an open cursor by releasing the current result set and freeing any cursor locks held on the rows on which the cursor is positioned. CLOSE leaves the data structures accessible for reopening, but fetches and positioned updates are not allowed until the cursor is reopened. CLOSE must be issued on an open cursor; it is not allowed on cursors that have only been declared or are already closed.

Syntax

CLOSE { { [ GLOBAL ] cursor_name } | cursor_variable_name }

Arguments

GLOBAL

Specifies that cursor_name refers to a global cursor.

cursor_name

Is the name of an open cursor. If both a global and a local cursor exist with cursor_name as their name, cursor_name refers to the global cursor when GLOBAL is specified; otherwise, cursor_name refers to the local cursor.

cursor_variable_name

Is the name of a cursor variable associated with an open cursor.

Examples

This example shows the correct placement of the CLOSE statement in a cursor-based process.

USE pubs
GO

DECLARE authorcursor CURSOR FOR 
SELECT au_fname, au_lname 
FROM authors
ORDER BY au_fname, au_lname

OPEN authorcursor
FETCH NEXT FROM authorcursor 
WHILE @@FETCH_STATUS = 0
BEGIN
   FETCH NEXT FROM authorcursor 
END

CLOSE authorcursor
DEALLOCATE authorcursor
GO

See Also

Cursors

DEALLOCATE

FETCH

OPEN

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.