Bulk Import Large-Object Data by using the OPENROWSET Bulk Rowset Provider (SQL Server)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
The SQL Server OPENROWSET Bulk Rowset Provider enables you to bulk import a data file as large-object data.
The large-object data types supported by OPENROWSET Bulk Rowset Provider are varbinary(max) or image, varchar(max) or text, and nvarchar(max) or ntext.
The image, text and ntext data types are deprecated.
The OPENROWSET BULK clause supports three options for importing the contents of a data file as a single-row, single-column rowset. You can specify one of these large-object options instead of using a format file. These options are as follows: