|
|
От: | senglory | |
| Дата: | 25.04.20 18:01 | ||
| Оценка: | |||
CREATE TABLE [dbo].[Zipcodes]
(
[ID] INT NOT NULL PRIMARY KEY IDENTITY,
[Zip] VARCHAR(5) NOT NULL
)["00101" ,"00102" ,"00103" ,"00206" ,"00210" ,"00112" ,"00616" ... ]Declare @JSON varchar(max)
SELECT @JSON=BulkColumn
FROM OPENROWSET (BULK 'C:\TMP\zipcodes.json', SINGLE_CLOB) import
insert into [dbo].[Zipcodes](
Zip
)
SELECT *
FROM OPENJSON (@JSON)
with(
[value] VARCHAR(5)
)Msg 515, Level 16, State 2, Line 23
Cannot insert the value NULL into column 'Zip', table 'dbo.Zipcodes'; column does not allow nulls. INSERT fails.