sql - 将 JSON 数据存储到 SQL 中

Question

任何人都可以确认代码有什么问题。我试图将 json 数据存储到 sql 中，但它显示错误。下面是代码

DECLARE @json varchar(max)='
    {
      "BusinessEntityID":1,
      "NationalIDNumber":"295847284",
      "JobTitle":"Chief Executive Officer",
      "BirthDate":"1969-01-29",
      "Gender":"M",
      "Contact":{"Home":"036/222-333","Mob":"064/3376222"}
   }   
';
 
SELECT * INTO Person
FROM OPENJSON(@json)
WITH (BusinessEntityID int,
         NationalIDNumber int,
         JobTitle varchar(100),
         BirthDate varchar(200),
         Gender varchar(2),
         Contact varchar(max)
)

错误消息：Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.

标签： sqljsonsql-serversyntax-error