DECLARE @AuthorID BIGINT

DECLARE c1 CURSOR READ_ONLY FOR 

SELECT ID FROM TABLE_1 --KAYNAK

OPEN c1

FETCH NEXT FROM c1

WHILE @@FETCH_STATUS = 0 BEGIN

INSERT INTO TABLE_2 (NAME) SELECT NAME FROM TABLE_1 WHERE ID=@AuthorID --HEDEF

FETCH NEXT FROM c1 INTO @AuthorID

END

CLOSE c1

DEALLOCATE c1

1 kişi tarafından 5.0 olarak değerlendirildi

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5