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.
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
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.
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
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?
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.
@@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?
Excellent work, exactly what one would need to get started. No fluff, just pure matter. Thank you.
Excellent teaching skills
Really got to know how this JSON Parsing worked.
Excellent video thanks a lot
Nice 👍
Really good and clearly explained
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.
👍
Very good presentation... but one thing is missing. A description of the json_modify and json_query functions.
why date conversion is not working with json format
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
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.
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
Hi Manoj, Can you please help me with writing SQL script using FOR JSON and get desired json output which has fixed schema..
sure email me your scenario manub22(at)gmail(dot)com
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?
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.
@@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?
Hi Manoj, I have a doubt. I have sent an email to you regarding the doubt. Kindly look into it.
Is this video based on SQL Server 2016 or SQL Server 2019?
SQL Server 2016, so it will also work with 2019
Hi Manoj Sir, please reply on mail 4 days before I have mailed you.
Hi Perminder, responded to your email, please check.