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, 2179🔥, 0💬
Popular Posts:
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...