SQL Server 2019

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

DECLARE @test nvarchar(max)

SET @test = 'We the People of the United States@  in Order to form a more perfect Union@ establish 
             Justice@ insure domestic Tranquility@ provide for the common defense@ promote the general 
             Welfare@ and secure the Blessings of Liberty to ourselves and our Posterity@ do ordain and 
              establish this Constitution for the United States of America@'

SELECT IDENTITY(int) as SerialNumber, s.value as text
INTO test1
FROM STRING_SPLIT(@test, '@') s
9 rows affected

select *
from test1


SerialNumber
text


1
We the People of the United States

2
  in Order to form a more perfect Union

3
 establish 
             Justice

4
 insure domestic Tranquility

5
 provide for the common defense

6
 promote the general 
             Welfare

7
 and secure the Blessings of Liberty to ourselves and our Posterity

8
 do ordain and 
              establish this Constitution for the United States of America

9



DECLARE @test nvarchar(max)

SET @test = 'We the People of the United States@  in Order to form a more perfect Union@ establish 
             Justice@ insure domestic Tranquility@ provide for the common defense@ promote the general 
             Welfare@ and secure the Blessings of Liberty to ourselves and our Posterity@ do ordain and 
              establish this Constitution for the United States of America@'

SELECT IDENTITY(int) as SerialNumber, s.value as text
INTO test2
FROM STRING_SPLIT(@test, '@') s
ORDER BY CHARINDEX('@' + s.value + '@', '@' + @test + '@')
9 rows affected

select * from test2


SerialNumber
text


1
We the People of the United States

2
  in Order to form a more perfect Union

3
 establish 
             Justice

4
 insure domestic Tranquility

5
 provide for the common defense

6
 promote the general 
             Welfare

7
 and secure the Blessings of Liberty to ourselves and our Posterity

8
 do ordain and 
              establish this Constitution for the United States of America

9

SerialNumber	text
1	We the People of the United States
2	in Order to form a more perfect Union
3	establish Justice
4	insure domestic Tranquility
5	provide for the common defense
6	promote the general Welfare
7	and secure the Blessings of Liberty to ourselves and our Posterity
8	do ordain and establish this Constitution for the United States of America
9