All Questions
2
questions
1
vote
1
answer
233
views
OpenJson to parse and partially update a json column column
I have this table:
CREATE TABLE [dbo].[Device]
(
[Id] [bigint] IDENTITY(1,1) NOT NULL,
[DeviceStatus] [int] NOT NULL,
[Type] [nvarchar](64) NOT NULL,
[Serial] [nvarchar](64) NOT NULL,
...
1
vote
1
answer
2k
views
How to get multiple columns of values from OPENJSON and cross apply
I am using SQL Server inside Visual Studio 2019. I have downloaded a large JSON file for US Zip codes. My goal is to get all the properties from the fields, which look like this:
and save their ...