@blob nvarchar (max): the JSON blob @schema_name sysname: the database schema in which to create tables (defaults to "dbo") @base_table_name sysname: if the JSON is not an object with an array, put ...

Finally, there is a FOR JSON clause that can format any result set returned by SQL query as JSON text: SELECT object_id, name FROM sys.tables FOR JSON PATH Check out the other posts in this four-part ...

Exult for SQL Server shreds the XML data to normal (relational) data, automatically creating the tables and columns as dictated by your XML structure.