Use of the SQL midstream mark and the SQL mark

Use of the SQL midstream mark and the SQL mark
Declare @ id int
Declare @ addTime datetime
Declare cursor1 cursor for -- defines the cursor cursor1
Select id, addtime from MR_Examine -- use the cursor object (enter select text as needed)
Open cursor1 -- open a cursor
Declare @ I int
Set @ I = 1
Fetch next from cursor1 into @ id, @ addTime -- move the cursor down one row and put the obtained data in the defined variable @ id and @ name.


While @ fetch_status = 0 -- determines whether data is successfully obtained
Begin
If (@ I> 10)
Set @ I = 1

Update MR_Examine set AddTime = DATEADD (DAY, @ I *-1, GETDATE () where Id = @ id -- perform corresponding processing (enter the SQL text as needed)
Set @ I = @ I + 1
Fetch next from cursor1 into @ id, @ addTime -- move the cursor down one row
End
Close cursor1 -- close the cursor
Deallocate cursor1