📮 Contact 🇧🇷 🇺🇸 🇫🇷
Declaring a variable with json content
Json content:
[
{
"name": "Flavio",
"code": "FLA-1",
"isDeleted": false
},
{
"name": "Contoso",
"code": "CON-1",
"isDeleted": true
}
]
-- SET JSON CONTENT TO A VARIABLE (@JSON)...
DECLARE @json NVARCHAR(max) = N'[
{
"name": "Flavio",
"code": "FLA-1",
"isDeleted": false
},
{
"name": "Contoso",
"code": "CON-1",
"isDeleted": true
}
]';
Fill a temp table with json content
-- FILL #TEMP TABLE WITH JSON CONTENT...
SELECT firstName, code, IIF(isDeleted = 1, 0, 1) as active
INTO #temp
FROM OPENJSON(@json)
WITH (
firstName VARCHAR(50) '$.name',
code VARCHAR(10) '$.code',
isDeleted BIT '$.isDeleted'
);
Show items from temp table
-- SHOW ITEMS FROM #TEMP TABLE
SELECT * FROM #temp;
If you need to drop temp table
-- REMOVE A #TEMP TABLE...
DROP TABLE #temp;
Typos or suggestions?
If you've found a typo, a sentence that could be improved or anything else that should be updated on this blog post, you can access it through a git repository and make a pull request. If you feel comfortable with github, instead of posting a comment, please go directly to https://github.com/campelo/documentation and open a new pull request with your changes.
Top comments (0)