JSON. Learn isjson, json_value, openjson for SQL Server.
In this video, I will teach you how to validate JSON with "isjson".
I will teach you how to use json_value and openjson. We will learn about LAX and STRICT.
I made this video for you. I hope you'll be able to implement the ARRAY data type in any table and use in your SQL statements, without the struggle I went through.
I made this video just for you, and I hope this will help you.
------------------------------------------------------*****------------------------------------------------------------
I would appreciate if you could leave a message for other students to read, a thumbs up if you learned something new and enjoyed the video, and please consider subscribing to this channel. Thank you in advance for your consideration.
Let's help each other!
------------------------------------------------------*****------------------------------------------------------------
We will also learn how to write a STORED PROCEDURE that takes JSON in as a parameter, and inserts rows into a table.
Test Compatibility_level, must be 130 or higher.
Use NVarchar and learn about UNICODE characters.
TimeLine
00:00 -begin
00:11 -compatibility level
00:56 -ALTER the compatibility level (warning, do not perform)
02:08 -is JSON valid
04:03 -Declare @table TABLE
05:03 -openjson example 1
06:06 -openjson example 2
07:13 -path modes lax and strict
08:31 -how to use jason_value
11:35 - create a stored procedure to save json object
software nuggets
On this page of the site you can watch the video online JSON. Learn isjson, json_value, openjson for SQL Server. with a duration of hours minute second in good quality, which was uploaded by the user Software Nuggets 09 September 2021, share the link with friends and acquaintances, this video has already been watched 1,925 times on youtube and it was liked by 24 viewers. Enjoy your viewing!
