我这样写了游标
DECLARE
@user_id int
DECLARE user_extension_cursor CURSOR FOR SELECT id FROM UserMember
OPEN user_extension_cursor;
FETCH NEXT FROM user_extension_cursor INTO @user_id
WHILE @@FETCH_STATUS = 0
BEGIN
UPDATE UserMember
SET AdminID = (SELECT Top 1 ID FROM dbo.Admin WHERE IsEnable=1 order by NEWID())
WHERE id = @user_id
FETCH NEXT FROM user_extension_cursor
INTO @user_id
END
CLOSE user_extension_cursor;
DEALLOCATE user_extension_cursor;