General MySQL Oracle SQL Server

Using Cursors in SQL Server Transact-SQL

Q

Where to find answers to frequently asked questions on Using Cursors in SQL Server Transact-SQL? I want to loop through rows in a result set.

✍: FYIcenter.com

A

Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Using Cursors in SQL Server Transact-SQL. Clear explanations and tutorial exercises are provided on declaring cursor names and cursor variables; open and close cursors; looping through cursor result set; backward scrolling; dynamic cursors.

What Are Cursors in SQL Server

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

"OPEN" - Executing the Query of a Cursor in SQL Server

"FETCH" - Fetching the Next Row from a Cursor in SQL Server

"FETCH" - Transferring Data from Cursors to Variables in SQL Server

"@@FETCH_STATUS" - Looping through Result Set in SQL Server

Declaring and Using Cursor Variables in SQL Server

SCROLL - Creating Cursors for Backward Scrolling in SQL Server

DYNAMIC - Creating Dynamic Cursors in SQL Server

 

⇒⇒SQL Server Transact-SQL Tutorials

2016-10-17, 618👍, 0💬

General MySQL Oracle SQL Server