Collections:
"DECLARE ... CURSOR" - Declaring Cursor Objects in SQL Server
How To Declare a Cursor with "DECLARE ... CURSOR" in SQL Server Transact-SQL?
✍: FYIcenter.com
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
⇒ "OPEN" - Executing the Query of a Cursor in SQL Server
⇐ What Are Cursors in SQL Server
2016-10-17, 2164🔥, 0💬
Popular Posts:
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...