DECLARE @Id VARCHAR(50) DECLARE db_cursor CURSOR FOR SELECT Id FROM Tabela OPEN db_cursor FETCH next FROM db_cursor INTO @Id WHILE @@FETCH_STATUS = 0 BEGIN UPDATE Tabela2 SET Nome = @Id WHERE Id_Estrutura = @Id ; FETCH next FROM db_cursor INTO @Id END CLOSE db_cursor DEALLOCATE db_cursor