"DECLARE ... CURSOR" - Declaring Cursor Objects in SQL Server

Q

How To Declare a Cursor with "DECLARE ... CURSOR" in SQL Server Transact-SQL?

✍: FYIcenter.com

A

If you want to use a cursor to represent the result set of a query, you need to define a cursor name with a SELECT sub-statement using the "DECLARE ... CURSOR" statement using the following syntax format:

DECLARE cursor_name CURSOR FOR
  SELECT ...; 

Note that the DECLARE statement will not actually execute the SELECT sub-statement. It only attaches the SELECT sub-statement to the cursor.

A cursor name should be deallocated to free up server resources if the cursor is not needed any more.

The tutorial example below shows you how to declare and deallocate a cursor.

USE FyiCenterData;
GO

DECLARE fyi_cursor CURSOR FOR
  SELECT * FROM fyi_links;
-- other statements
DEALLOCATE fyi_cursor;
GO

 

Using Cursors in SQL Server Transact-SQL

⇒⇒SQL Server Transact-SQL Tutorials

2016-10-17, 917👍, 0💬