Most RecentMost ViewedMost LikesLesson 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.Lesson 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.
