How to insert json data directly into table in sql.

-
Let us consider the below JSON as sample data,

ex: [{
"info": [{
"id": 1,
"name": "John",
"surname": "Smith",
"age": 25
},
{
"id": 2,
"name": "Abijal",
"surname": "Smith",
"age": 45
},
{
"id": 3,
"name": "Abhijit",
"surname": "singh",
"age": 41
}]
}]

To insert the above JSON we can use the below query,

Query:

declare @json varchar(max) =' [{ "info": [{ "id": 1, "name": "John", "surname": "Smith", "age": 25 }, { "id": 2, "name": "Abijal", "surname": "Smith", "age": 45 }, { "id": 3, "name": "Abhijit", "surname": "singh", "age": 41 }] }] ' Insert into EmployeeDetails SELECT Id,Age,FirstName,LastName from( SELECT * FROM OpenJson(@json)
WITH (inffo NVARCHAR(MAX) '$.info' AS JSON) OUTER APPLY OpenJson(inffo) WITH ( Id VARCHAR(30) '$.id',FirstName VARCHAR(30) '$.name',LastName VARCHAR(30) '$.surname',Age VARCHAR(30) '$.age') ) as empdetails

Popular posts from this blog

Implement virtualisation in kendo drop down list using jquery ajax in mvc, aspx page

-
virtualization helps to load huge data fastly. $("#abcd").kendoDropDownList({                 filter: "contains",                 dataTextField: "WorkOrderNumber",                 dataValueField: "WorkOrderNumber",                 virtual: {                     itemHeight: 26,                     valueMapper: function (options) {                     }     ...
Read more

How to Create trigger to Update the NoofOrgs Count under each category in Category Table based on Temp Table in Sql Server

-
--creating a trigger CREATE TRIGGER [dbo].UPDATEORGSCOUNTINCATEGORY_AFTERINSERT_FROMORGANISATIONS]   ON --here we mention the table name   [dbo].[Organisations] --here we can have insert, update, delete as trigger point --I want to execute my trigger when a record is inserted in organizations table (step-1) --then get the count of orgs in each category from organisationcategories table and save it in temp table(step-2) --then update the category table with orgs count in each category(step-3)   AFTER INSERT   AS   BEGIN   --we are updating the count bcz a listing or nonprofi can be approved or rejected then the count changes. --creating a temp table with two columns of int type DECLARE @temp TABLE ( CategoryId INT, NoofOrgs INT ) --inserting values into temp table INSERT INTO @temp SELECT * from (         --here we are selecting these two columns select CategoryId,ISNULL(NoofOrgs , 0) AS 'NoofOrgs' from (   ...
Read more

How to Preview the image and download which is in base64string format in mvc view using C#

-
  <div class="col-lg-9 col-xl-6">                                                     @if (reclaimdetai != null)                                                     {                                                         @foreach (var item in reclaimdetai.RequestFileList)                                                         {                                 ...
Read more