Most RecentMost ViewedMost LikesLesson Learned #504: Inserting Records from a CSV File using OPENROWSET into TempDB Today, I would like to share how to insert records from a CSV file stored in Azure Blob Storage into a temporary table in TempDB in Azure SQL Database using OPENROWSET and a format file. Lesson Learned #34: Does Azure SQL Database support OPENJSON?First published on MSDN on Mar 24, 2018 The answer is Yes! but your database needs to have in the compatibility level 130 or above.
