Collections:
"FETCH" - Transferring Data from Cursors to Variables in SQL Server
How To Transfer Data from a Cursor to Variables with a "FETCH" Statement in SQL Server Transact-SQL?
✍: FYIcenter.com
By default, a FETCH statement will display the fetched row on the client program window. If you want to transfer the output data to variables, you can specify an INTO clause with a list of variables that matches the list of fields in the result set.
The tutorial exercise below shows you a good example of using the FETCH statement to transfer one row of output data from the result set to variables:
USE FyiCenterData; GO DECLARE fyi_cursor CURSOR FOR SELECT id, url, notes, counts, time FROM fyi_links; OPEN fyi_cursor; DECLARE @id INT, @url VARCHAR(80), @notes VARCHAR(80), @counts INT, @time DATETIME; FETCH NEXT FROM fyi_cursor INTO @id, @url, @notes, @counts, @time; PRINT 'id = '+CONVERT(VARCHAR(20),ISNULL(@id,0)); PRINT 'url = '+ISNULL(@url,'NULL'); PRINT 'notes = '+ISNULL(@notes,'NULL'); PRINT 'counts = '+CONVERT(VARCHAR(20),ISNULL(@counts,0)); PRINT 'time = '+CONVERT(VARCHAR(20),ISNULL(@time,'2007')); CLOSE fyi_cursor; DEALLOCATE fyi_cursor; GO id = 101 url = dev.fyicenter.com notes = NULL counts = 0 time = Jan 1 2007 12:00AM
⇒ "@@FETCH_STATUS" - Looping through Result Set in SQL Server
⇐ "FETCH" - Fetching the Next Row from a Cursor in SQL Server
2016-10-17, 1464🔥, 0💬
Popular Posts:
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...