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