Skip to content

Commit 310ed77

Browse files
author
Matthew Sebolt
authored
Update while-transact-sql.md
1 parent 95bdbf7 commit 310ed77

1 file changed

Lines changed: 1 addition & 2 deletions

File tree

docs/t-sql/language-elements/while-transact-sql.md

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -98,12 +98,11 @@ SELECT LoginID, JobTitle
9898
FROM AdventureWorks2012.HumanResources.Employee
9999
WHERE JobTitle = 'Marketing Specialist';
100100
OPEN Employee_Cursor;
101-
FETCH NEXT FROM Employee_Cursor;
102101
FETCH NEXT FROM Employee_Cursor INTO @EmployeeID, @Title;
103102
WHILE @@FETCH_STATUS = 0
104103
BEGIN
105104
Print ' ' + @EmployeeID + ' '+ @Title
106-
FETCH NEXT FROM Employee_Cursor;
105+
FETCH NEXT FROM Employee_Cursor INTO @EmployeeID, @Title;
107106
END;
108107
CLOSE Employee_Cursor;
109108
DEALLOCATE Employee_Cursor;

0 commit comments

Comments
 (0)