SQL Server Cursor
Join the DZone community and get the full member experience.Join For Free
// Syntax for a t-sql server cursor
DECLARE @AuthorID char(11) DECLARE c1 CURSOR READ_ONLY FOR SELECT au_id FROM authors OPEN c1 FETCH NEXT FROM c1 INTO @AuthorID WHILE @@FETCH_STATUS = 0 BEGIN PRINT @AuthorID FETCH NEXT FROM c1 INTO @AuthorID END CLOSE c1 DEALLOCATE c1
Opinions expressed by DZone contributors are their own.