I have created table like:
x
CREATE TABLE demo
(
name varchar(50),
adress nvarchar
);
But I’m not getting how to insert data into adress
column which stores data of JSON object like:
INSERT INTO demo (name, adress)
VALUES ('vamsi', N'{"city":"avhfb","pin":46374});
Like this: The values I get in this adress
column is dynamic count so that’s why I need to store it in JSON format.
Advertisement
Answer
Don’t overthink it. JSON is still a string, so nvarchar
will be fine, but add a length to they datatype (probably nvarchar(max)
for a JSON object).