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
Nesta página do site você pode assistir ao vídeo on-line JSON. Learn isjson, json_value, openjson for SQL Server. duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Software Nuggets 09 Setembro 2021, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 1,925 vezes e gostou 24 espectadores. Boa visualização!
