1-) MSSQL Athena -  TABLODAKİ BİR TANE ROW' U ÇOĞALTMA RECNO'SUNU DEĞİŞTİREREK

INSERT INTO PBPARL (PBPARL_RECNO,PBPARL_DBX) SELECT '188',PBPARL_DBX FROM PBPARL WHERE PBPARL_RECNO = '187'

2-) BU YOL DAHA GÜZEL

SELECT * INTO PBPARL_COPY FROM PBPARL WHERE PBPARL_RECNO IN('189','190')

declare @sayac int=0

declare @count int=0

set @count =(SELECT COUNT(PBPARL_RECNO) FROM PBPARL_COPY)

while(@sayac<>@count-1)

begin

set @sayac=@sayac+1

UPDATE PBPARL_COPY SET PBPARL_RECNO=PBPARL_RECNO+(@count)

end

INSERT INTO PBPARL SELECT * FROM PBPARL_COPY

DROP TABLE PBPARL_COPY

3-) YUKARIDAKININ AYNISI SADECE BIR SUTUN EKLENMİŞ

SELECT * INTO PBPARL_COPY FROM PBPARL WHERE PBPARL_RECNO IN('193','194')

declare @sayac int=0

declare @count int=0

set @count =(SELECT COUNT(PBPARL_RECNO) FROM PBPARL_COPY)

while(@sayac<>@count-1)

begin

set @sayac=@sayac+1

UPDATE PBPARL_COPY SET PBPARL_RECNO=PBPARL_RECNO+(@count) , PBPARL_PBPARH_ID='96'

end

INSERT INTO PBPARL SELECT * FROM PBPARL_COPY

DROP TABLE PBPARL_COPY