SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT *
INTO dbo.YourTable
FROM (VALUES(1,1,'sometext'),
            (1,2,'anothertext'),
            (1,3,'someverydifferenttext'))V(ID,Version,Content)
3 rows affected

INSERT INTO dbo.YourTable
SELECT ID,
       ROW_NUMBER() OVER (ORDER BY Version) + MAX(Version) OVER () AS Version,
       Content
FROM dbo.YourTable;
3 rows affected

SELECT *
FROM dbo.YourTable


ID
Version
Content


1
1
sometext

1
2
anothertext

1
3
someverydifferenttext

1
4
sometext

1
5
anothertext

1
6
someverydifferenttext


DROP TABLE dbo.YourTable;

ID	Version	Content
1	1	sometext
1	2	anothertext
1	3	someverydifferenttext
1	4	sometext
1	5	anothertext
1	6	someverydifferenttext