As the most-requested feature on the Microsoft SQL Server connect site ... However, the OPENJSON function can return any complex object. Finally, there is a FOR JSON clause that can format any result ...

The bcp utility bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server ...