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
En esta página del sitio puede ver el video en línea JSON. Learn isjson, json_value, openjson for SQL Server. de Duración hora minuto segunda en buena calidad , que subió el usuario Software Nuggets 09 septiembre 2021, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 1,925 veces y le gustó 24 a los espectadores. Disfruta viendo!
