The use of the SQL Midstream label

DECLARE @id int
DECLARE @addTime datetime
Declare cursor1 cursor for--defines a cursor Cursor1
Select Id,addtime from Mr_examine--object with cursor (fill in select text as required)
Open Cursor1--opening cursors
DECLARE @i int
Set @i=1
FETCH NEXT from the Cursor1 into @id, @addTime--moves the cursor down by 1 rows, gets the data into the previously defined variable @id, @name


While @ @fetch_status = 0--Determine if the data was successfully obtained
Begin
if (@i>10)
Set @i=1

Update Mr_examine Set Addtime=dateadd (Day,@i*-1,getdate ()) Where [email protected]-do the appropriate processing (as required Fill in the SQL text)
Set @[email protected]+1
FETCH NEXT from Cursor1 into @id, @addTime--Move cursor down 1 rows
End
Close Cursor1--closing cursors
Deallocate Cursor1

The use of the SQL Midstream label