SQL Server cursors write to themselves

Declare @Id varchar( -)--Define two local variables @id @name global variable is two @ @nameDeclare @Name varchar( -) DeclareCurCursor  for--Define a cursorSelectId,name fromTEMP1--query statement return ID and nameOpenCur--Open cursorFetch Next  fromCur into @Id,@Name--assigns the value returned by the cursor to the local variable (hint: The return value on the right is a one-piece return next representing the next one each time) while @ @fetch_status=0--Define a while loopBegin Update Temp Set [C3]=@Name where [ID]  like @Id+'%' Fetch Next  fromCur into @Id,@Name End CloseCurdeallocateCur

SQL Server cursors write to themselves