Update the inserted SQL transaction statement using the cursor Loop

-- Start transaction
Begin tran

-- Do Not Display count Information
Set nocount on

Declare @ userid varchar (512)
Declare @ A int
Set @ A = 10000

-- Declare a cursor
Declare crmpscontact_cursor cursor
Select [userid] from [gmcc]. [DBO]. [cvv_users]

-- Open the cursor
Open crmpscontact_cursor

-- Return the value of the first row to the variable.
Fetch next from crmpscontact_cursor
Into @ userid

-- Execute the statement
Update [gmcc]. [DBO]. [cvv_users]
Set [workid] = @
Where [userid] = @ userid
Set @ A = @ A + 1

-- Execution error rollback
If @ error! = 0
Begin
Rollback tran
Return
End

-- Move the cursor and update all other rows (exit when the cursor ends)
While @ fetch_status = 0
Begin
-- Move the cursor to the next row
Fetch next from crmpscontact_cursor
Into @ userid

-- Execute the statement, starting from the second line
Update [gmcc]. [DBO]. [cvv_users]
Set [workid] = @
Where [userid] = @ userid

Set @ A = @ A + 1

-- Execution error rollback
If @ error! = 0
Begin
Rollback tran
Return
End

End

-- Close the cursor
Close crmpscontact_cursor

-- Release cursor
Deallocate crmpscontact_cursor

-- Submit all changes
Commit tran

-- Restore settings
Set nocount off
Go