Cursor

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