HomeНаука и техникаRelated VideosMore From: Bert Wagner

Convert JSON to CREATE TABLE Statements

13 ratings | 554 views
In this episode I share a query I wrote to automatically parse a JSON object into SQL Server CREATE TABLE statements. Related blog post with example code: https://bertwagner.com/2018/05/22/converting-json-to-sql-server-create-table-statements/ Github: https://github.com/bertwagner/SQLServer/blob/master/JSONtoSQLGenerator.sql Twitter: https://twitter.com/bertwagner
Html code for embedding videos on your blog
Text Comments (6)
Prashant Rangaraju (2 months ago)
your awesome dude. thx so much!!! can you do this using groovy script?
Bert Wagner (2 months ago)
Thanks for watching! Sorry I’m not a Java guy so you’re on your own with groovy.
Wilbur Sean Bvuma (3 months ago)
been looking all over the net for a function like yours and nothing, great work Bert.
Bert Wagner (3 months ago)
Glad you can use it!
Orestes Zoupanos (4 months ago)
sp_BlitzJSON ? ^_^
Bert Wagner (4 months ago)
Hah! You’d have to talk to Brent about that one!

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.