How to move tuples to another table?

Question

SQL

Hello!

I parsed the data, and wrote the data to a json file, after which I transferred this data to a table:

select Name, CapitalCity, LargestCity, Admission, Population from OpenJson('
[
  {
    "name": "Alabama",
    "capitalCity": "Montgomery",
    "largestCity": "Birmingham",
    "admission": "Dec 14, 1819",
    "population": "4,903,185"
  }, ...
')
with (
  Name nvarchar(20) '$.name',
  CapitalCity nvarchar(30) '$.capitalCity',
  LargestCity nvarchar(20) '$.largestCity',
  Admission nvarchar(20) '$.admission',
  Population nvarchar(20) '$.population'
)

Created a table:

create table State(
  ID int not null,
  Name nvarchar(20) not null,
  CapitalCity nvarchar(30) not null,
  LargestCity nvarchar(30) null,
  Admission nvarchar(20) null,
  Population nvarchar(20) not null,

  primary key(ID),
)

And how can I now transfer the converted json data to the table that is in the database?

Answer 1

INSERT INTO MyTABLE (Name, CapitalCity, LargestCity, Admission, Population)
select Name, CapitalCity, LargestCity, Admission, Population from OpenJson('
[
  {
    "name": "Alabama",
    "capitalCity": "Montgomery",
    "largestCity": "Birmingham",
    "admission": "Dec 14, 1819",
    "population": "4,903,185"
  }, ...
')
with (
  Name nvarchar(20) '$.name',
  CapitalCity nvarchar(30) '$.capitalCity',
  LargestCity nvarchar(20) '$.largestCity',
  Admission nvarchar(20) '$.admission',
  Population nvarchar(20) '$.population'
)