Excellent work, exactly what one would need to get started. No fluff, just pure matter. Thank you.
@vishaljhaveri7565
8 ай бұрын
Really got to know how this JSON Parsing worked.
@lakshmaiahkolli6867
Жыл бұрын
Excellent teaching skills
@suvradeepbanerjee6801
Жыл бұрын
Excellent video thanks a lot
@anthonyscott4476
2 жыл бұрын
Excellent video Manoj, easy to follow with greate explanations (love the inclusion of errors as these add to the learning experience and assist with troubleshooting). As Dariusz mentioned, inclusion of addition JSON functions would put the cherry on the cream.
@balajeecomputek9041
Жыл бұрын
Nice 👍
@dariuszspiewak5624
2 жыл бұрын
Very good presentation... but one thing is missing. A description of the json_modify and json_query functions.
@legocreation8689
Жыл бұрын
👍
@funmidijo285
4 ай бұрын
Really good and clearly explained
@sachingupta5985
Жыл бұрын
why date conversion is not working with json format
@vnPride75
7 ай бұрын
Hello Sir, at the first part how to create the JSON Data how can i build the structure with a list(Array)? Like if you have also Hobbies [ Name{}, type{}].... thank you very much
@fatimahussain9004
2 жыл бұрын
Hello Manjo, thanks for the very informative video. You gave a very good example of customer information with their order detail in one table in JSON form. Can you tell me how can I append customer more orders with the existing orders? please share your video if you made on it.
@sushiwolf688
Жыл бұрын
Hello Manoj, i am really new with SQL, i was wondering how would the 28:19 querry look in mysql, do you perhaps has a documentation or an example on how to do it in mysql? i really appreciate it if you could show or teach me
@rajath1384
2 жыл бұрын
Hi Manoj, Can you please help me with writing SQL script using FOR JSON and get desired json output which has fixed schema..
@SQLwithManoj
2 жыл бұрын
sure email me your scenario manub22(at)gmail(dot)com
@deeprajmazumder6261
Жыл бұрын
Hi Manoj, I have a doubt. I have sent an email to you regarding the doubt. Kindly look into it.
@itsmeutkarsh
2 жыл бұрын
Hi Manoj, thanks for the awesome video. I have inserted a JSON object in my table. Now I want to validate that any new record that I insert, should be of the same format as the first record i.e. it should have a same number of tags. How do we put such validation during insert in sql server?
@SQLwithManoj
2 жыл бұрын
Hi Utraksh, as the JSON column datatype is VARCHAR, so you can apply CHECK constraint on it, and can do validations for INSERT statements. If the validations are complex you can create a UDF and call it in CHECK constraint. But it will slow down a bit while you do bulk insert in the table.
@itsmeutkarsh
2 жыл бұрын
@@SQLwithManoj Thanks for the prompt response Manoj. One quick question: As you told, can we store something like JSON schema in UDF and use that to validate every new JSON record being inserted?
@LesGainous
2 жыл бұрын
Is this video based on SQL Server 2016 or SQL Server 2019?
@SQLwithManoj
2 жыл бұрын
SQL Server 2016, so it will also work with 2019
@permindersingh7836
3 жыл бұрын
Hi Manoj Sir, please reply on mail 4 days before I have mailed you.
@SQLwithManoj
3 жыл бұрын
Hi Perminder, responded to your email, please check.
Пікірлер: 24