T-SQL - syntactic sugar for updating current row in cursor

I am not a big fan of cursors, however for time to time I have to write one. In my case cursor usually is responsible for some complicated updates. Until yesterday I’ve been writing my update statements within the cursor the standard way

1
-- cursor code omitted for brevity
2
-- some complicated update
3
UPDATE Person.Person set FirstName = 'some logic goes here' where Person.BusinessEntityID = @Id
4
where @Id variable is set by cursor.
5
-- cursor code omitted for brevity

There is nothing wrong with that, however we can do the same thing using specialized syntax - current of keyword(s)

1
UPDATE Person.Person set FirstName = 'some logic goes here' where current of personCursor

The entire cursor statement then looks that way

1
DECLARE personCursor CURSOR FOR SELECT top 1000 * FROM Person.Person
2
OPEN personCursor
3
FETCH NEXT FROM personCursor
4
WHILE @@FETCH_STATUS = 0
5
BEGIN
6
   -- some complicated update goes here
7
   UPDATE Person.Person set FirstName = 'some logic goes here' where current of personCursor
8
   FETCH NEXT FROM personCursor
9
END
10
CLOSE personCursor
11
DEALLOCATE personCursor