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, 1363🔥, 0💬
Popular Posts:
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...